To update 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. On the Tools menu in the CONNX Data Dictionary Manager window, click Update Statistics.

  2. The CONNX Database Logon dialog box appears.

    image\view_05.jpg
     

  3. Log in using your CONNX user name and password for all databases to update.

  4. The Update CONNX Statistics dialog box appears with messages stating that the databases have been successfully updated.

    image\toolmenu_06.jpg