Skip to Content
1
Former Member
Jan 28, 2009 at 12:18 AM

Query on Index of BSIK table

43 Views

Hi , I am using a query which extracts data from BSIK table with where condition on budat(Posting Date in the Document). When i checked in SQL Trace (ST05) the select query is executed with index BSIK~4 ( Index 4) where Index 4 does not contain BUDAT or budat is not part of any index.So, Can any one explain me the reason behind whey the SQL optimizer picked index 4?

Thank You,

Regards,

Swaroop Patri