|
1878.5.4
by Brian Aker
Update documentation. |
1 |
CREATE INDEX
|
2 |
============
|
|
3 |
||
|
2194.5.3
by Andrew Hutchings
Markup fixes |
4 |
.. code-block:: mysql |
5 |
||
6 |
CREATE [UNIQUE] INDEX index_name [USING {BTREE | HASH}] ON table_name (column_name [length] [ASC | DESC], ...); |
|
|
1878.5.4
by Brian Aker
Update documentation. |
7 |
|
|
2194.5.2
by Andrew Hutchings
Fix SQL markup |
8 |
An example: |
9 |
||
10 |
.. code-block:: mysql |
|
|
1994.4.85
by Marisa Plumb
create index (no fast index creation) |
11 |
|
12 |
CREATE INDEX table_1_index ON table_1 (a,b); |
|
13 |
||
14 |
This would create an index on table_t named table_1_index that converged |
|
|
1878.5.4
by Brian Aker
Update documentation. |
15 |
columns a and b. |
|
1994.5.33
by Stewart Smith
add FIXME for CREATE INDEX implementation should be documented |
16 |
|
|
2194.5.2
by Andrew Hutchings
Fix SQL markup |
17 |
Fast index creation (where a storage engine can create or drop indexes without copying and rebuilding the contents of the entire table) is not implemented yet for Drizzle, but it is slated for the future. |