Simple life, Complicated mind
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:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment