Rebuilding IQ Indexes

As you develop a PDM or modify an existing one, you may change data types, alter the percentage of distinct values or change the number of values in tables. You must then rebuild the IQ indexes to reflect these changes.

1. Select Tools > Rebuild Objects > Rebuild Indexes to open the Rebuild Indexes dialog box:
   
   
2. Select a default name to generates IQ indexes. You can use the following variables:
   
   

   • %COLUMN% - Column name

   • %INDEXTYPE% - Type of index to be rebuilt

   • %TABLE% - Name or code of table (based on display preferences)

3. Specify a mode to use. You can choose between:
   
   

   • Delete and Rebuild - All existing indexes are deleted before index rebuild

   • Preserve Indexes - Preserves all existing indexes

4. [optional] Select the Update statistics before rebuild checkbox to update such statistics as the number of records in a table and the number of distinct values in a column before performing the rebuild. Selecting this option can help with optimizing the rebuild.
5. [optional] Click the Selection tab and select or clear checkboxes to specify for which tables you want to rebuild indexes.
   
   
6. Click OK, and then Yes to confirm the rebuilding of your indexes.