Revision [991]
Last edited on 2007-10-02 19:50:21 by WikiAdminDeletions:
Revision [990]
Edited on 2007-10-02 19:50:03 by WikiAdminAdditions:
=== Rebuild an index ===
repair table xxx.table1 quick;
=== Locate indexes ===
select TABLE_SCHEMA, TABLE_NAME, INDEX_NAME, INDEX_TYPE from statistics;
repair table xxx.table1 quick;
=== Locate indexes ===
select TABLE_SCHEMA, TABLE_NAME, INDEX_NAME, INDEX_TYPE from statistics;
Revision [237]
Edited on 2007-04-17 08:06:05 by WikiAdminAdditions:
create index INDEX_NAME on TABLE_NAME (COL1(10) ASC,COL2(30) DESC);
# create an index on COL1 using first 10 bytes in acceding order, and COL2 using first 30 bytes in descending order.
=== Drop an index ===
drop index INDEX_NAME on TABLE_NAME;
# create an index on COL1 using first 10 bytes in acceding order, and COL2 using first 30 bytes in descending order.
=== Drop an index ===
drop index INDEX_NAME on TABLE_NAME;
Deletions:
Revision [236]
Edited on 2007-04-17 08:02:59 by WikiAdminAdditions:
=== Query existing indexes ===
show index from TABLE_NAME;
show index from TABLE_NAME;
