SQL语句， 以下语句不会导致全表扫描的是.
Aselect id from t where substring(name, 1,3)=‘cif‘
Bselect id from t where name like ‘cif%‘
Cselect id from table_1 where num=10 or num=20
Dselect id from t where createdate>=‘20 05- 11-30‘ and createdate
Aselect id from t where substring(name, 1,3)=‘cif‘
Bselect id from t where name like ‘cif%‘
Cselect id from table_1 where num=10 or num=20
Dselect id from t where createdate>=‘20 05- 11-30‘ and createdate