This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:creation:updating [2012/01/30 16:39] doc |
admin:indexing:creation:updating [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| ====== Administration: Omnidex Indexing ====== | ====== Administration: Omnidex Indexing ====== | ||
| - | ===== Indexing Creation ===== | + | ===== Index Creation ===== |
| [[admin:indexing:creation:home|Overview]] | | [[admin:indexing:creation:home|Overview]] | | ||
| Line 11: | Line 11: | ||
| [[admin:indexing:creation:files|Index Files]] | | [[admin:indexing:creation:files|Index Files]] | | ||
| [[admin:indexing:creation:performance|Performance]] | [[admin:indexing:creation:performance|Performance]] | ||
| + | ---- | ||
| ==== Updating Indexes ==== | ==== Updating Indexes ==== | ||
| Line 47: | Line 47: | ||
| </code> | </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> | ||
| ==== ==== | ==== ==== | ||