SQLSERVER select * from lsetlist with(index=PK_LSetList) where FYear=2016 and fsetcode=1 ORACLE## select * /*+index(lsetlist,PK_LSetList)*/ from lsetlist where FYear=2016 and fsetcode=1