数据表建建立复合索引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;正确答案B