单选题

现有数据库表t_order,主键为Forder_id,并在表的Fuin、Fstate、Fcreate、ime建立复合索引，下列选项中能使索引的是（ ）

Question

现有数据库表t_order,主键为Forder_id,并在表的Fuin、Fstate、Fcreate、ime建立复合索引，下列选项中能使索引的是（    ）

A. select Fmerchant_id,Fuin FROM t_order WHERE Forder_id=&rsquo27000022016041412037866&rsquo

B. select Fmerchant_id,Forder_id FROM t_order WHERE Fuin=&rsquo42176034&rsquo AND Fstate=1

C. select Fmerchant_id,Fuin,Fstate FROM t_order WHERE Forder_id LIKE &lsquo%20160414%&rsquo

D. select Fmerchant_id,Famount FROM t_order WHERE Forder_id=&rsquo27000022016041412037866&rsquo OR Fuin=&rsquo42176034&rsquo