现有数据库表t_order,主键为Forder_id,并在表的Fuin、Fstate、Fcreate、ime建立复合索引,下列选项中能使索引的是()。
A.selectFmerchant_id,FuinFROMt_orderWHEREForder_id=‘27000022016041412037866’;
B.selectFmerchant_id,Forder_idFROMt_orderWHEREFuin=’42176034’ANDFstate=1;
C.selectFmerchant_id,Fuin,FstateFROMt_orderWHEREForder_idLIKE‘%20160414%’;
D.selectFmerchant_id,FamountFROMt_orderWHEREForder_id=’27000022016041412037866’ORFuin=’42176034’;
- · 有4位网友选择 D,占比40%
- · 有3位网友选择 A,占比30%
- · 有2位网友选择 C,占比20%
- · 有1位网友选择 B,占比10%