This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
dev:sql:statements:create_index_group:home [2009/12/04 16:10] tdo created |
dev:sql:statements:create_index_group:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ====== Omnidex SQL: CREATE INDEX GROUP ====== | ====== Omnidex SQL: CREATE INDEX GROUP ====== | ||
| + | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| + | ^ 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 SQL> | + | <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] | ||
| - | + | </code> | |
| - | ===== Discussion ===== | + | |
| - | == arg1 == | ||
| - | |||
| - | == arg2 == | ||
| - | |||
| - | ===== Examples ===== | ||
| - | |||
| - | ==== Simple ==== | ||
| - | |||
| - | ==== 2nd example ==== | ||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||