Select using Indexed field, still using sequential read

[Former Member]

Hi Experts,

I am selecting from CATSDB table

SELECT SINGLE * FROM catsdb

WHERE belnr = var.

BELNR is indexed so I am expecting that this statement will do a direct read.

But when this statement is run, SAP message indicates that

it is performing a sequential read. Anybody knows why this is? And how do I make direct read happen?

Thank you very much for your help.

Bes Regards,

Rose

[Former Member]

Hi,

may be you need to update the database statistics for that table or you need to recreate the index. Check out db02 for the table or make some check using se14.

regards

Siggi

PS: Also fm rsdu_analyze_tables will be of some help. do a test run in se37 and enter the name of the table.

Message was edited by:

Siegfried Szameitat