Skip to Content
3
Former Member
Jul 03, 2007 at 11:01 AM

Where clause with IN operator to use index?

239 Views

Hi,

If all the where fields are using IN in select statements will it uses the index to retrieve data from the table.

Example.

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

FROM SAPR3.RBKP

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.

Regards,

Karthik.k