Skip to main content

New in InterSystems IRIS 2022.3

This page describes the new and enhanced features in the 2022.3 release of InterSystems IRIS®, which is a Continuous Delivery (CD) release.

For a more exhaustive list of the changes included in this release, refer to the Upgrade ChecklistOpens in a new tab.

Enhancing Developer Experience

SQL Development

InterSystems SQL now offers a machine-readable format for query plans. Using this new option, the $SYSTEM.SQL.Explain() method will now produce a JSON-based rendering of the query plan with significantly more detail on the plan itself as well as the tables and indexes it accesses. Where the previous XML-based format used simple English phrases to describe different steps, the new format is easier to consume for tools that wish to perform more thorough analysis or graphical rendering of query plans.

This release introduces an opt-in capability to sample runtime parameters for SQL statements. The Statement Index already records a rich set of metadata such as detailed runtime statistics and query plans for each statement, which typically has any literals substituted for placeholders that parameterize the cached query code. Now, the statement index can be extended with a sampling of the actual runtime values for those parameters. These can then be combined with the normalized statement text to, for example, build a representative workload that can be run against another deployment, for example to benchmark a new hardware environment or experiment with a different set of indexes for the schema. 

InterSystems SQL now supports CREATE SCHEMA and DROP SCHEMA commands to include in scripts for setting up and tearing down your application environment.

Enhancing Analytics and AI

This release provides the following enhancements to analytics and AI:

Enhancing Speed, Scale, and Security

This release offers full elasticity for Sharded clusters. DBAs can now call an API method to mark a shard for removal. The method offloads data from the designated shard to other data nodes in the cluster and automatically disconnects the node when all data buckets have been successfully moved to other shards. This process leverages the same mechanism as Online Rebalancing, meaning users can continue to query sharded tables and ingest data into them while the data is being moved. 

Platform Updates

This release adds support for the following new server platforms:

  • Oracle Linux 9

  • SUSE 15 SP4

FeedbackOpens in a new tab