This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:features:rollups:indexing [2012/02/17 16:39] doc |
admin:features:rollups:indexing [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 20: | Line 20: | ||
| The following example shows indexing for the tables that were created in the previous page. | The following example shows indexing for the tables that were created in the previous page. | ||
| - | <code sql> | + | <code> |
| create table "INDIVIDUALS" | create table "INDIVIDUALS" | ||
| physical "dat/individuals.dat" | physical "dat/individuals.dat" | ||
| Line 75: | Line 75: | ||
| </code> | </code> | ||
| + | Indexes on rollup tables are automatically updated when the UPDATE INDEXES statement is issued: | ||
| + | |||
| + | <code> | ||
| + | > update indexes | ||
| + | Database | ||
| + | Table Rows CPU Elapsed | ||
| + | ---------------------------------------------------------------------------- | ||
| + | SIMPLE | ||
| + | COUNTRIES 239 0:00 0:00 | ||
| + | STATES 76 0:00 0:00 | ||
| + | GENDERS 2 0:00 0:00 | ||
| + | HOUSEHOLDS 1,909 0:00 0:00 | ||
| + | INDIVIDUALS 5,000 0:00 0:00 | ||
| + | INDIVIDUALS_BY_HOUSEHOLD 5,000 0:00 0:00 | ||
| + | INDIVIDUALS_BY_DEMO 4,793 0:00 0:00 | ||
| + | ---------------------------------------------------------------------------- | ||
| + | Total 0:01 0:03 | ||
| + | |||
| + | Omnidex indexes updated | ||
| + | > | ||
| + | </code> | ||
| ==== ==== | ==== ==== | ||
| **[[admin:features:rollups:create|Prev]]** | **[[admin:features:rollups:optimization|Next]]** | **[[admin:features:rollups:create|Prev]]** | **[[admin:features:rollups:optimization|Next]]** | ||
| + | |||
| ====== Additional Resources ====== | ====== Additional Resources ====== | ||