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

Home -> Community -> Usenet -> c.d.o.server -> Re: Puzzing performance results with SQL

Re: Puzzing performance results with SQL

From: JUngruh <joachim.ungruh_at_cardinal.com>
Date: 30 Jan 2004 11:59:44 -0800
Message-ID: <4b880313.0401301159.6275c7c7@posting.google.com> 





The database is using its Rule based optimizer(RBO).  Its either set
at the database level (optimzer_mode init.ora parameter) or statistics
have never been gathered on those tables, which will cause Oracle to
use the RBO.


When using the RBO, the order in which the tables are listed in the
from clause is very important.
Received on Fri Jan 30 2004 - 13:59:44 CST












Original text of this message













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