Hi all,
I would like to know how will be the performance of a select query, which contains one primary key field and few other non-primary key fields in the where clause.
for example:
select vbeln posnr fkimg vrkme prsdt netwr matnr arktx mwsbp subfam
codcol codcoat epaiscom codtyp length width
into corresponding fields of table it_vbrp
from vbrp
for all entries in it_vbrk
where vbeln = it_vbrk-vbeln (primary key) and
subfam in s_subfam (non-key field) and
codcol in s_codcol (non-key field) and
codcoat in s_coat (non-key field) and
epaiscom in s_thick (non-key field).
Thanks,
Rajan