DRAFT

Omnidex SQL: UPDATE INDEXES

Description

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.

Syntax

UPDATE INDEXES [FOR <ENVIRONMENT [environment] 
                    DATABASE database |
                    TABLE table | 
                    COLUMN column | 
                    INDEX index > ] 
                [ON [INSTANCE] instance]
                [WITH options]

Examples

Update Indexes for DATABASE

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>

Update Indexes for TABLE

odxsql> update indexes for database simple table states
Update indexes for STATES
Omnidex indexes updated ...
odxsql>