Skip to Content
0
Former Member
Apr 19, 2010 at 01:43 PM

Select is not using the Index

1200 Views

Hi,

I have a Z-Table. The Primary key is:

EQUNR and LFDNR

I created now a new index with the field: EQUNR BSTNK .

Now I entered 3 equnrs and bstnk like 07* in SE16n

Normally what I thought should happen is that it uses the index to read the three equipments and than checks the field bstnk.

Instead it does a sequentiel read of the hole table that contains 12mio entries!

When I enter the bstnk more qualified like 0712354* the search is fast (1sec). Why is SAP bypassing the index and does a sequentiel read instead?!