|
1878.5.4
by Brian Aker
Update documentation. |
1 |
CREATE INDEX
|
2 |
============
|
|
3 |
||
4 |
CREATE [UNIQUE] INDEX index_name [USING {BTREE | HASH}] ON table_name (column_name [length] [ASC | DESC], ...);
|
|
5 |
||
6 |
An example: |
|
7 |
||
8 |
CREATE INDEX table_1_index ON table_1 (a,b); |
|
9 |
||
10 |
This would create an index on table_t named table_1_index that convered |
|
11 |
columns a and b. |