Re: What's this SQL doing?

From: Thomas Kellerer <spam_eater_at_gmx.net>
Date: Thu, 06 Nov 2003 11:27:18 +0100
Message-ID: <bod7m6$1bu8rt$1@ID-13919.news.uni-berlin.de>

Prince Of Thieves schrieb:

> Select c.clridx, n.price, n.perprice
> from clr c, sprice_clrsku n where c.styleidx = 1164
> and c.styleidx = c.styleidx and c.active = 1 and c.colouridx > 0 and
> n.spidx(+) = 163
> and n.clridx(+) = c.clridx order by c.clrcode;
>
> Notice the line "and c.styleidx = c.styleidx "? Why did the author set this
> SQL like this? Is this to accomplish something I do not know about?
>

I'm doing this pretty often as well. Mostly because you can force Oracle to use an index on that column by including it this way. We have seen radical changes in the execution plan by adding conditions like that.

Thomas Received on Thu Nov 06 2003 - 04:27:18 CST