Tasks After Upgrading to Release 2.2

After upgrading to NuoDB 2.3, perform the following tasks:

Running ANALYZE on Tables

In NuoDB 2.2, it is recommended that you run ANALYZE on all of your tables and indexes to ensure highly optimized query plans. Execute the following command:

ANALYZE ALL TABLES IN SCHEMA schema

For more information, see ANALYZE.

Updating Default Templates

The built-in automation templates shipped with NuoDB were updated in release 2.2. If you installed NuoDB 2.2 and performed a cold restart of your database then the new templates are available to you. If you performed a rolling upgrade then you need to use NuoDB Manager to run the following command to make the updated templates available:

update defaultTemplates

For details about this command, see update defaultTemplates.