select count(*) as aggregate from `call_records` where (`CallType` = 'dialout' and `CalledNo` = '12345678910'); 這條查詢如何優化?前提是不能建立索引,因為這張表里面已經有好幾個索引了,有可能導致鎖表。 查看完整描述