为自己加油

数据表建建立复合索引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;