多选题

下列哪种查询无法使用B+Tree索引进行优化

Question

A. select * from test where a=10

B. select * from test where a=10 or b=5

C. select * from test where a=10 and b>5

D. select * from test where a=10 order by b desc