This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
dev:sql:statements:create_table:home [2010/07/07 20:57] els |
dev:sql:statements:create_table:home [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 19: | Line 19: | ||
===== Table Characteristics ===== | ===== Table Characteristics ===== | ||
- | The CREATE TABLE statement declares the characteristics of the table. At a minimum, each table has a name and instructions for accessing the physical data. Omnidex supports configuration settings for each table, including settings for [[dev:sql:statements:create_table:delimited_files | delimited files]], [[dev:sql:statements:create_table:data_cache | data caches ]] and [[dev:sql:statements:create_table:index_maintenance | index maintenance]]. Omnidex also provides [[admin:optimization:rollups:home | rollup tables]] which pre-aggregate another table in the database and automatically optimize queries against the table. | + | The CREATE TABLE statement declares the characteristics of the table. At a minimum, each table has a name and instructions for accessing the physical data. Omnidex supports configuration settings for each table, including settings for [[dev:sql:statements:create_table:delimited_files | delimited files]], [[dev:sql:statements:create_table:data_cache | data caches ]] and [[dev:sql:statements:create_table:index_maintenance | index maintenance]]. Omnidex also provides [[admin:features:rollups:home | rollup tables]] which pre-aggregate another table in the database and automatically optimize queries against the table. |
===== Columns Characteristics ===== | ===== Columns Characteristics ===== | ||
Line 48: | Line 48: | ||
* [[admin:indexing:home|Indexing Strategies]] | * [[admin:indexing:home|Indexing Strategies]] | ||
* [[dev:appendix:articles:dbspe|Database-specific issues]] | * [[dev:appendix:articles:dbspe|Database-specific issues]] | ||
- | * [[admin:optimization:rollups:home|Rollup Tables]] | + | * [[admin:features:rollups:home|Rollup Tables]] |
{{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} |