请问,这个SQL,怎么加索引才好?
SELECT COUNT(COUNT) COT FROM app_service WHERE `key`='804292e42b9b7179f64e364080fb62f8' OR `key`='0e9680eed7f5ffc60a7b02167d0182a3' AND dt >='2014-02-01' AND dt <='2014-02-10'
数据结构:
FieldTypeComment
dtdate NULL
servicevarchar(20) NULL
ctvarchar(20) NULL
pkgvarchar(128) NULL
keyvarchar(128) NULL
refervarchar(128) NULL
uvint(8) unsigned NULL
countint(10) unsigned NULL
isValidtinyint(1) NULL
majorVersionvarchar(8) NULL
我EXPLAIN了一下,只能达到ALL,郁闷了;
这是索引:
Index Information
IndexesColumnsIndex_Type
NewIndex1dt, isValid
NewIndex2service
NewIndex3dt
NewIndex4dt, key