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

Query on Index of BSIK table


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,


Swaroop Patri