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