This shows you the differences between two versions of the page.
|
admin:indexing:creation:updating [2012/01/30 17:00] doc |
admin:indexing:creation:updating [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ~~NOTOC~~ | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | ====== Administration: Omnidex Indexing ====== | ||
| - | |||
| - | ===== Indexing Creation ===== | ||
| - | |||
| - | [[admin:indexing:creation:home|Overview]] | | ||
| - | [[admin:indexing:creation:declaring|Declaring Indexes]] | | ||
| - | **[[admin:indexing:creation:updating|Updating Indexes]]** | | ||
| - | [[admin:indexing:creation:files|Index Files]] | | ||
| - | [[admin:indexing:creation:performance|Performance]] | ||
| - | |||
| - | ==== Updating Indexes ==== | ||
| - | |||
| - | When Omnidex indexing is added to an Omnidex Environment, only the metadata about each index is added to the environment. The indexes themselves are not populated until an UPDATE INDEXES statement is issued. This is of great benefit since it allows multiple indexes to be built with one scan of the table. Omnidex applications frequently use many Omnidex indexes, and building them individually would be prohibitively slow. The example below updates all of the indexes for a table. | ||
| - | |||
| - | <code> | ||
| - | > update indexes for table HOUSEHOLDS | ||
| - | Database | ||
| - | Table Rows CPU Elapsed | ||
| - | ---------------------------------------------------------------------------- | ||
| - | SIMPLE | ||
| - | HOUSEHOLDS 1,909 0:00 0:00 | ||
| - | ---------------------------------------------------------------------------- | ||
| - | Total 0:00 0:00 | ||
| - | |||
| - | Omnidex indexes updated | ||
| - | > | ||
| - | </code> | ||
| - | |||
| - | Most commonly, administrators update the indexes for all tables in the environment with one command, as shown below. | ||
| - | |||
| - | <code> | ||
| - | > update indexes | ||
| - | Database | ||
| - | Table Rows CPU Elapsed | ||
| - | ---------------------------------------------------------------------------- | ||
| - | SIMPLE | ||
| - | HOUSEHOLDS 1,909 0:00 0:00 | ||
| - | INDIVIDUALS 5,000 0:00 0:00 | ||
| - | ---------------------------------------------------------------------------- | ||
| - | Total 0:00 0:03 | ||
| - | |||
| - | Omnidex indexes updated | ||
| - | > | ||
| - | </code> | ||
| - | |||
| - | If needed, an individual index can be populated without affecting the other indexes, so long as the index was created with the STANDALONE option. | ||
| - | |||
| - | <code> | ||
| - | > update indexes for index HOUSEHOLDS.STATE_CITY_ZIP; | ||
| - | Database | ||
| - | Table Rows CPU Elapsed | ||
| - | ---------------------------------------------------------------------------- | ||
| - | SIMPLE | ||
| - | HOUSEHOLDS 1,909 0:00 0:03 | ||
| - | ---------------------------------------------------------------------------- | ||
| - | Total 0:00 0:04 | ||
| - | |||
| - | Index (HOUSEHOLDS)HOUSEHOLDS.STATE_CITY_ZIP updated | ||
| - | > | ||
| - | </code> | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||