Skip to Content
0
Former Member
Apr 23, 2009 at 05:45 PM

Peformance problem with PRPS table

52 Views

I have appended a field (ZREFWBS) to the PRPS table and I am using the below quey to get the single record.

SELECT posid

psphi

FROM prps

INTO (v_pspnr,

v_psphi)

UP TO 1 ROWS

WHERE zzrefwbs = ci_prps-zzrefwbs.

ENDSELECT.

It is taking almost 5 to 10 mins to execute.

Please suggest.

Thanks in Advance.

Moderator message - moved to correct forum

Edited by: Rob Burbank on Apr 23, 2009 2:02 PM