This shows you the differences between two versions of the page.
admin:indexing:creation:updating [2012/01/30 16:38] 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 data. Omnidex applications frequently involve many Omnidex indexes, and building them individually would be prohibitively slow. The example below updates 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> | ||
- | |||
- | |||
- | |||
- | ==== ==== | ||
- | |||
- | **[[admin:indexing:creation:declaring|Prev]] | [[admin:indexing:creation:files|Next]]** | ||
- | |||
- | |||
- | ====== Additional Resources ====== | ||
- | |||
- | See also: | ||
- | |||
- | {{page>:admin:indexing:see_also&nofooter&noeditbtn}} | ||
- | |||
- | {{page>:bottom_add&nofooter&noeditbtn}} |