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:41] 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 ROLLUPS statement is issued: | + | Indexes on rollup tables are automatically updated when the UPDATE INDEXES statement is issued: |
<code> | <code> | ||
Line 95: | Line 95: | ||
Omnidex indexes updated | Omnidex indexes updated | ||
> | > | ||
- | </code? | + | </code> |
==== ==== | ==== ==== | ||
**[[admin:features:rollups:create|Prev]]** | **[[admin:features:rollups:optimization|Next]]** | **[[admin:features:rollups:create|Prev]]** | **[[admin:features:rollups:optimization|Next]]** |