"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/create_index.rst" (6 May 2012, 545 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

CREATE INDEX

CREATE [UNIQUE] INDEX index_name [USING {BTREE | HASH}] ON table_name (column_name [length] [ASC | DESC], ...);

An example:

CREATE INDEX table_1_index ON table_1 (a,b);

This would create an index on table_t named table_1_index that converged columns a and b.

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.