Index behaviour in select query and in database view?? for EKET and EKPO

184 Views

Hi,

I am writing a select query to fetch EBELN and EBELP from EKET table using the delivery date EINDT which is one of the secondary indexes for the table, just this one field. But then it takes too much of a time to fetch the information using this select query. While if I give the same information in the SE16 screen it seems to run faster!! Can anyone explain how can something like this happen??

Also the EBELN and EBELP from the EKET table has been passed to EKPO table to verify for the plant as in selection screen, which again takes a very long time inspite of passing both the key fields. Where as I tried only passing EBELN from EKET to EKPO which works much faster...how can this be possible? I am stuck with this tricky problem.

Can anyone please help me with this. Thanks in advance.

Regards,

Soms