Re: Possible Performance Improvement to Select Statement

From: Paul Izzo <paul.izzo_at_mosca-ag.com>
Date: 3 Feb 2005 06:56:13 -0800
Message-ID: <1107442573.581138.125290@z14g2000cwz.googlegroups.com>

I recieved the following code this from another forum now my query runs a lot better!! Feel free to use this as an example for your own SQL scripts.

select distinct pkvk.KD_VORGANGS_NR
from w100.pkvk,w100.pkvp,
(select distinct pkvk.KD_VORGANGS_NR

      from   w100.pkvp,w100.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) x

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=x.KD_VORGANGS_NR(+)

    and x.KD_VORGANGS_NR is null Received on Thu Feb 03 2005 - 08:56:13 CST