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_index_group:home [2010/07/02 18:20] tdo |
dev:sql:statements:create_index_group:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 6: | Line 6: | ||
| ^ See Also: ^ [[dev:sql:statements:create_environment:home | Create Environment ]] ^^ [[dev:sql:statements:create_database:home| Create Database ]] ^ [[dev:sql:statements:create_table:home | Create Table]] ^ [[dev:sql:statements:create_index:home | Create Index ]] ^ | ^ See Also: ^ [[dev:sql:statements:create_environment:home | Create Environment ]] ^^ [[dev:sql:statements:create_database:home| Create Database ]] ^ [[dev:sql:statements:create_table:home | Create Table]] ^ [[dev:sql:statements:create_index:home | Create Index ]] ^ | ||
| ===== Description ===== | ===== Description ===== | ||
| + | |||
| + | The CREATE INDEX GROUP will create an Omnidex Group that can be used to group columns together during indexing to facilitate retrieval. | ||
| ===== Syntax ===== | ===== Syntax ===== | ||
| <code> | <code> | ||
| CREATE INDEX GROUP [(owner)]group | CREATE INDEX GROUP [(owner)]group | ||
| - | (table.index, table.index [, table.index ...]) | + | (table_spec.index, table_spec.index [, table_spec.index ...]) |
| IN “filename” | IN “filename” | ||
| [WITH options] | [WITH options] | ||