← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/create_index.rst

  • Committer: Monty Taylor
  • Date: 2011-02-13 17:26:39 UTC
  • mfrom: (2157.2.2 give-in-to-pkg-config)
  • mto: This revision was merged to the branch mainline in revision 2166.
  • Revision ID: mordred@inaugust.com-20110213172639-nhy7i72sfhoq13ms
Merged in pkg-config fixes.

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/create_index.rst
1
1
CREATE INDEX
2
2
============
3
3
 
4
 
.. code-block:: mysql
5
 
 
6
 
   CREATE [UNIQUE] INDEX index_name [USING {BTREE | HASH}] ON table_name (column_name [length] [ASC | DESC], ...);
 
4
CREATE [UNIQUE] INDEX index_name [USING {BTREE | HASH}] ON table_name (column_name [length] [ASC | DESC], ...);
7
5
 
8
6
An example:
9
7
 
10
 
.. code-block:: mysql
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
 
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
15
11
columns a and b.
16
12
 
17
 
Fast index creation (where a storage engine can create or drop indexes
18
 
without copying and rebuilding the contents of the entire table) is
19
 
not implemented yet for Drizzle, but it is slated for the future.
 
13
FIXME: how this is implemented currently. i.e. no fast add index