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}} | ||