现在，有一个组合索引（A,B,C），可以有哪几种查询方式？

“`考察点：sql语句

 

优: select * from test where a=10 and b>50

差: select * from test where b = 50

 

优: select * from test order by a

差: select * from test order by b

差: select * from test order by c

 

优: select * from test where a=10 order by a

优: select * from test where a=10 order by b

差: select * from test where a=10 order by c

 

优: select * from test where a>10 order by a

差: select * from test where a>10 order by b

差: select * from test where a>10 order by c

 

优: select * from test where a=10 and b=10 order by a

优: select * from test where a=10 and b=10 order by b

优: select * from test where a=10 and b=10 order by c

 

优: select * from test where a=10 and b=10 order by a

优: select * from test where a=10 and b>10 order by b

差: select * from test where a=10 and b>10 order by c

“`

Was this helpful?

YesNo

0 / 0