Skip to Content
0
Former Member
Jul 30, 2007 at 12:38 PM

Any alternative for the query performance wise

30 Views

Hi,

Please help me with an alternative for the below query performance wise, without using for all entries. No matter if you suggest for declaring some int. tables or whatever but main issue is performance.

SELECT gpart vkont

INTO TABLE t_bpca_md

FROM fkkvkp

FOR ALL ENTRIES IN t_db_pos_match

WHERE gpart = t_db_pos_match-partner

AND opbuk NE c_siebel

AND vkpbz = 'AC'.

Thanks.

Binay.