Skip to Content
0
Former Member
Mar 17, 2009 at 03:47 AM

performance if where clause has 1 key field +non-key fields?

1318 Views

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