为自己加油

数据表建建立复合索引tab_index (“name” ,”age”) ,下面哪些语句能用上索引 ( ) 。

A.select*from table where age=18 and name=’test’;
B.select*from table where name=’test’and age=18;
C.select*from table where name like”%test%”and age=18;
D.select*from table where name like”%test”and age=18;