Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Optimization of query finding related products for a certain product

Re: Optimization of query finding related products for a certain product

From: David Cressey <david_at_dcressey.com>
Date: Mon, 10 Sep 2001 21:11:42 GMT
Message-ID: <i0an7.672$Iw2.29288@petpeeve.ziplink.net>


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.com
Received on Mon Sep 10 2001 - 16:11:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US