how to avoid this code?

HI all,

i want to improve performance of my program

could anyone suggest how to avoid this

" SELECT werk UP TO 1 ROWS

INTO l_iwerk

FROM ser03

WHERE obknr IN ( select OBKNR

from OBJK

WHERE equnr EQ p_equnr

AND taser EQ 'SER03' )."

Moderator message: please don't open new discussions for each similar issue, also search for available information before posting.

Message was edited by: Thomas Zloch