If all the where fields are using IN in select statements will it uses the index to retrieve data from the table.
I have created index for fields BUKRS,BUDAT,RBSTAT,LIFNR and uses the following select.
SELECT BELNR, GJAHR, BLART, CPUDT, BUKRS, LIFNR, RMWWR, RBSTAT, ZUONR
WHERE BUKRS IN BUKRS
AND BUDAT IN BUDAT
AND RBSTAT IN RBSTAT
AND LIFNR IN LIFNR
AND BELNR IN BELNR
will it use the index. My basis person is saying this table uses full scan even after creating index on these fields, is it because of IN in where clause.