Updating Statistics in the CONNX Data Dictionary Manager
The Update Statistics function updates index and performance information about the tables that is stored in the CONNX Data Dictionary. This information is used by CONNX to form query plans and perform cross-database query optimization.
To update statistics in the CONNX Data Dictionary Manager:
1. Click Tools -> Update Statistics in the CONNX Data Dictionary Manager window.
2. Log in using your CONNX user name and password for all databases.
The Update CONNX Statistics dialog box appears with messages stating that the databases have been successfully updated.