New Features

For more information, see Log-Structured Archive (LSA).

For more information, see Merge Tree Indexing.

To display the quantities and a size histogram of each type of atom in LSA, use nuoarchive check --show-stats. For more information, see NuoDB Archive - Checking.

Added Java 21 runtime support for the Administrative Process (AP) and the JDBC driver. For more information, see System Requirements.

During a database upgrade, the messages logged to nuoadmin.log include the storage group ID on which the update has been applied.

For more information, see MULTIINDEXES System Table Description.

For more information, see LASTSTATEMENT System Table Description.

For more information, see TABLES System Table Description.

For more information, see CONNECTIONS System Table Description.

For more information, see COLUMNGROUPS System Table Description, and COLUMNGROUPFIELDS System Table Description.

For more information, see SQL Table Functions.

For more information, see DROP TRIGGER, CREATE TRIGGER, and TRIGGERS System Table Description.

For more information, see Predefined Storage Groups.

For more information, see BUILTINFUNCTIONS System Table Description.

For more information, see Remove the Identity Property of a Generated Column.

For more information, see NuoDB Archive - Checking.

For more information, see NuoDB Archive - Restoring.

To specify the type of archive used to restore, use the nuocmd restore archive --archive-type <archive_type> argument, and to specify the type of archive used to start a containerized SM, use the nuocmd start sm --archive-type <archive_type> argument.

For more information, see NuoDB Command Reference and Docker-specific NuoDB Command Reference.

For more information, see SELECT.

Upgrade to the current release to apply the latest NuoDB security patches.

Hibernate 6 generated JOIN group syntax that wraps join predicates in parentheses was not supported in NuoDB. For example, Hibernate 6 generated SQL query such as, SELECT * FROM a JOIN (b JOIN c on x) on y, is now supported.

For more information, see Execution Plan Operators.

For more information, see Execution Plan Operators and Supported Spill to Disk Operations.

See the example on Connection Properties.

SQL queries that include variables are now recompiled to generate a more optimized execution plan, resulting in better performance and faster execution times.

For more information, see SELECT and RIGHT OUTER Join Operations.

SQL queries that include a variable in the LIKE operator are now considered for reoptimization by the v3 optimizer.

The optimizer will consider more 'Bitmap intersections' than before, providing additional opportunities to find an optimal access path. In particular, if a specific index is chosen to satisfy a property such as a join predicate or ordering, it will now check if that index can be further improved by intersecting it with additional indices.

For more information, see Setting nuoadmin.conf Properties.

The EXPLAIN (ANALYZE_GRAPH {ON|OFF}) option displays the Graphviz representation of the explain plan. Use any Graphviz viewer to produce a graphical representation of the explain plan to aid in debugging and troubleshooting complex query plans.

For more information, see EXPLAIN.

When executing a SQL query that includes a comparison operation of a string or a timestamp to a date literal, a performance optimization has been added by converting the operand opposite the date literal to a date.

For more information, see Using Optimizer Hints.

For more information, see WITH.

For more information, see Execution Plan Operators.