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

Home -> Community -> Usenet -> c.d.o.misc -> Re: LBO/CBO

Re: LBO/CBO

From: Marc Zinzen <mzinzen_at_genese.de>
Date: Fri, 27 Sep 2002 13:55:37 +0200
Message-ID: <3D944739.9DB6C71E@genese.de> 





Hi.



Sorry to bother again.


Two more questions came up.


1. If the Rulebase Optimizer executes a query how does it read its predicates.
Left to right or right to left.


2. The CBO. I have 2 tables. One very big. One very small. What happens when the
Selectivity value is the same. Will the optimizer acces the table with the least
results first?



Marc
Received on Fri Sep 27 2002 - 06:55:37 CDT












Original text of this message













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