Maintenance
UPDATE INDEXES Update Omnidex Indexes.
UPDATE ROLLUP TABLE Update Rollup Table with summarized information.
UPDATE ROLLUPS Update all Rollup Tables for an Omnidex Database.
UPDATE STATISTICS Update Statistics Information.
UPDATE TEXT Update Textual Statistics.
PARTITION Partition a table into smaller sub tables based on criteria.
LOAD OFX Load Indexes for a table.
INSTALL INDEXES Specifies the Omnidex indexes into the Omnidex XML Environment. No indexing is performed.
REMOVE INDEXES Removes the Omnidex indexes from the Omnidex XML Environment.
———————————–—————————————————————————————————————————————————–
 
Back to top
dev/sql/statements/index_maintenance/home.txt · Last modified: 2012/10/26 15:00 (external edit)