Skip to Content
0
Former Member
Sep 21, 2007 at 07:15 AM

Select using Indexed field, still using sequential read

29 Views

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