This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
dev:sql:statements:create_table:home [2010/07/06 22:30] els |
dev:sql:statements:create_table:home [2010/07/07 20:57] els |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | ----- | ||
| - | ----- | ||
| - | ^ Omnidex SQL Quicklinks ^^^^ | + | ^ Omnidex SQL Quicklinks ^^^^^ |
| - | |[[dev:sql:overview | Overview ]] | [[dev:sql:statements:home | Statements ]] | [[ dev:sql:functions:home | Functions ]] | [[dev:sql:home | Quick Reference ]] | | + | |[[dev:sql:overview | Overview ]] | [[dev:sql:statements:home | Statements ]] | [[ dev:sql:functions:home | Functions ]] | [[ dev:sql:examples:home | Examples ]] | [[dev:sql:home | Quick Reference ]] | |
| - | ----- | ||
| - | ----- | ||
| ====== Omnidex SQL: CREATE TABLE ====== | ====== Omnidex SQL: CREATE TABLE ====== | ||
| - | **[[dev:sql:statements:create_table:home|Overview]]** -> [[dev:sql:statements:create_table:syntax|Syntax]] -> [[dev:sql:statements:create_table:topics|Topics]] -> [[dev:sql:statements:create_table:examples|Examples]] | + | **[[dev:sql:statements:create_table:home|Overview]]** | [[dev:sql:statements:create_table:syntax|Syntax]] | [[dev:sql:statements:create_table:examples|Examples]] |
| Line 23: | 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 [[dev:sql:statements:create_table:rollup_tables | 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:optimization:rollups:home | rollup tables]] which pre-aggregate another table in the database and automatically optimize queries against the table. |
| ===== Columns Characteristics ===== | ===== Columns Characteristics ===== | ||
| Line 36: | Line 32: | ||
| Like most databases, Omnidex allows indexes to be declared using the CREATE INDEX statement. For convenience, Omnidex also allows indexes to be declared using the CREATE TABLE statement. In most applications, many (if not all) of the columns are indexed with Omnidex, so it is convenient to declare the indexing directly in the table specification. | Like most databases, Omnidex allows indexes to be declared using the CREATE INDEX statement. For convenience, Omnidex also allows indexes to be declared using the CREATE TABLE statement. In most applications, many (if not all) of the columns are indexed with Omnidex, so it is convenient to declare the indexing directly in the table specification. | ||
| - | |||
| ===== Inlining ===== | ===== Inlining ===== | ||
| - | Omnidex allows constraints and indexing to be declared alongside each column. With [[dev:sql:statements:create_table:inlining | inlining]], the constraint and indexing specification is provided as each column is declared. This is a convenience for simple installations where most constraints and indexes consist of a single column. | + | Omnidex allows constraints and indexing to be declared alongside each column. With inlining, the constraint and indexing specification is provided as each column is declared. This is a convenience for simple installations where most constraints and indexes consist of a single column. |
| | | ||
| + | |||
| ====== Additional Resources ====== | ====== Additional Resources ====== | ||
| See also: | See also: | ||
| - | * [[dev:sql:statements:create_database:home|CREATE DATABASE]] | ||
| * [[dev:sql:statements:create_environment:home|CREATE ENVIRONMENT]] | * [[dev:sql:statements:create_environment:home|CREATE ENVIRONMENT]] | ||
| + | * [[dev:sql:statements:create_database:home|CREATE DATABASE]] | ||
| * [[dev:sql:statements:create_index:home|CREATE INDEX]] | * [[dev:sql:statements:create_index:home|CREATE INDEX]] | ||
| * [[dev:sql:statements:update_indexes:home|UPDATE INDEXES]] | * [[dev:sql:statements:update_indexes:home|UPDATE INDEXES]] | ||
| Line 51: | Line 47: | ||
| * [[admin:indexing:home|Indexing Strategies]] | * [[admin:indexing:home|Indexing Strategies]] | ||
| - | * [[dev:appendix:articles:dbspecific:home|Database-specific issues]] | + | * [[dev:appendix:articles:dbspe|Database-specific issues]] |
| * [[admin:optimization:rollups:home|Rollup Tables]] | * [[admin:optimization:rollups:home|Rollup Tables]] | ||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||