The Omnidex UPDATE INDEXES statement reads the data specified in the Omnidex Environment and synchronizes the Omnidex indexes for an entire database or for an individual table.
If the Omnidex indexes have not been previously synchronized, then the UPDATE INDEXES statement will create the physical OS files needed to store the Omnidex index information using the information from the files/index prefix specified in the CREATE DATABASE statement.
If the Omnidex indexes have been previously synchronized, then the UPDATE INDEXES statement will re-use the existing index files by first removing the existing index information and re-synchronizing the Omnidex indexes by re-reading the data.
UPDATE INDEXES [FOR <ENVIRONMENT [environment]
DATABASE database |
TABLE table |
COLUMN column |
INDEX index > ]
[ON [INSTANCE] instance]
[WITH options]
odxsql> update indexes for database SIMPLE Updated indexes for COUNTRIES Updated indexes for STATES Updated indexes for GENDERS Updated indexes for HOUSEHOLDS Updated indexes for INDIVIDUALS Omnidex indexes updated environment SIMPLE_ENV odxsql>
odxsql> update indexes for database simple table states Update indexes for STATES Omnidex indexes updated ... odxsql>