Re: Possible Performance Improvement to Select Statement

I don't understand your reply Jens I'm using 2 tables (pkvk and pkvp) perhaps it's better when I post the untranslated version for our German posters (I translated parts of the select statement so that our English speaking posters can understand better)

Original (German):

select distinct pkvk.KD_VORGANGS_NR
from pkvk,pkvp
where pkvk.VORGANGS_STATUS != 9
and pkvp.KD_VORGANGS_NR = pkvk.KD_VORGANGS_NR and pkvp.KD_VORGANGS_ART = pkvk.KD_VORGANGS_ART and pkvk.KD_VORGANGS_NR

not in (select distinct pkvk.KD_VORGANGS_NR from pkvp,pkvk

where  pkvk.VORGANGS_STATUS != 9
and    pkvp.KD_VORGANGS_NR = pkvk.KD_VORGANGS_NR
and    pkvp.KD_VORGANGS_ART = pkvk.KD_VORGANGS_ART
and    pkvp.POSITIONS_STATUS != 9)