行行比较查询最优

1、行行比较

SELECT *  FROM S_MODEL_TYPE_info  WHERE
( S_MODEL, S_TYPE ) IN (('MODEL_1', 'TYPE_1'),('MODEL_1','TYPE_2'),('MODEL_2','TYPE_2'))

2、or

SELECT *  FROM S_MODEL_TYPE_info  WHERE
(S_MODEL='MODEL_1' and  S_TYPE in ('TYPE_1','TYPE_2')
or (S_MODEL='MODEL_2' and  S_TYPE = 'TYPE_2')