优化sql

怎么优化这句SQL:

select * from abc where a=123 and b=456 order by c limit 10;

 

ab建立联合索引，c建单独索引

 

联合索引的概念需要好好补补