Tuesday, January 5, 2010

add index

ALTER TABLE table_name DROP INDEX LatestTradeDate, ADD INDEX id_Key_LatestTradeDate USING BTREE(ID_KEY, LatestTradeDate);

ALTER TABLE table ADD INDEX LatestTradeDate USING BTREE(LatestTradeDate);

No comments: