Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Optimization of query finding related products for a certain product
Anurag,
> Whoever said that!! Though in this case, it might not bring any
improvement.
> There are *some* cases in which using procedural method is the best way to
> go.
>
I agree completely with you, here.
With regard to EXISTS, I'm a little surprised. DEC Rdb always use to give
me BETTER response with
EXISTS, when appropriate, because the optimizer had a special "fast first"
algorithm it could use in that case.
My understanding was that the CBO put into Oracle V8 was heavily influenced
by DEC Rdb's optimizer.
Oracle bought DEC Rdb in 1994, and called it Oracle Rdb. I wonder what
went wrong with EXISTS.
I've never had such bad luck with EXISTS in Oracle, either. But I may not have put it to a severe enough test.
-- Regards, David Cressey www.dcressey.comReceived on Mon Sep 10 2001 - 16:11:42 CDT