This is an old revision of the document!


DRAFT

Omnidex SQL: UPDATE INDEXES

Description

UPDATE INDEXES will synchronize and build the Omnidex indexes for a connected Omnidex Environment.

Syntax

UPDATE INDEXES [ FOR < ENVIRONMENT [environment] 
                    | DATABASE database
                    | TABLE table_spec 
                    | COLUMN column_spec 
                    | INDEX index_spec > ]
               [ON [INSTANCE] instance]
               [WITH options]

Discussion

UPDATE INDEXES

If no qualifier is specified, the UPDATE INDEXES statement will build all the Omnidex Indexes for the connected Omnidex Environment.

UPDATE INDEXES FOR specifier

A specific Database, Table,

Examples

Simple

2nd example

 
Back to top
dev/sql/statements/update_indexes/home.1278054216.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)