Description
Updates or rebuilds indexes in a specified column or for all columns in an attached table.
Syntax
Update_Index (table_name, column_name, rebuildflag)
Parameters
Parameters are as follows.
| Parameter | Description |
|---|---|
| table_name | The name of the table whose indexes are updated or rebuilt. If table_name is null, and rebuildflag is false (0) or null, all indexes for all attached tables are updated. |
| column_name | Update or rebuild all indexes for the specified column. If column_name is null, and rebuildflag is false (0) or null, all indexes for table_name are updated. If column_name is null, and rebuildflag is True (1), all indexes for table_name are rebuilt. |
| rebuildflag | If rebuildflag is true (1), indexes are rebuilt. |
The table_name contains a system delimiter.
See also
Create_Index, Delete_Index, List_Index
Example
/* Updates the index on the PART_NAME column in the CAR_PARTS table. */
Call Update_Index ("CAR_PARTS", "PART_NAME", "")
/* Rebuilds indexes on the PART_NAME column in the CAR_PARTS table. */
Call Update_Index ("CAR_PARTS", "PART_NAME", "1")
1 Comment
Don Bakke
OpenInsight 10 introduces a new argument in the 4th position: bSuppressMsg. This Boolean value appears to be a flag to suppress a message UI that indicates progress of the index update process.