Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: Why does a query go from 4 secs to 2 hrs due to using NOT IN instead of NOT EXISTS
In article <09q9e09gjo3nfg0h06s31ljk9709gcu0p0_at_4ax.com>, sybrandb_at_hccnet.nl wrote:
>On 1 Jul 2004 12:14:09 -0500, colin_lyse_at_yahsd.com (colin_lyse) wrote:
>You should also do away with your upper() on the lefthand side of all
>your conditions in the where clause of your index, as the likely
>result is you can't use an index anymore, as the full table scan on
>lm_exception_list is actually showing you.
thanks that did it, taking away the upper changed it
>Also you should replace the b.id in your subquery by 'x'.
>If your b.id doesn't occur in an index, the table will be read. If you
>are using 'x', the subquery will just read the index.
what do u mean by 'x' how od i change b.id to 'x', do you mean put 'b.id'? Received on Tue Jul 06 2004 - 12:53:09 CDT