Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Query on Index of BSIK table

Former Member
0 Kudos
133

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

4 REPLIES 4

Former Member
0 Kudos
58

Total Questions: 15 (15 unresolved)

Forum Points: 120

Rob

Former Member
0 Kudos
58

Index BSIK~4 exists in database system ORACLE, its the reason behind the picking.

Regards,

CK

Former Member
0 Kudos
58

it is exist in oracal data base system that why picking

ThomasZloch
Active Contributor
0 Kudos
58

Down to 6 unresolved...

None of the existing indexes supports BUDAT access, so probably the "least worst" index is chosen.

For BUDAT access try a join of BKPF and BSIK (see existing view BKPF_BSIK). Always include BUKRS in the selection.

Thomas