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 -> Proper Optimization selection.

Proper Optimization selection.

From: Asif H. rajwani <asif_at_noln.com>
Date: 1997/07/04
Message-ID: <33BD0355.9970D5E3@noln.com>#1/1

Hi,

    I have couple of questions about oracle optimization.

  1. What kind of optimizer is better to use Rule based or Cost based. When one would use the rule based or cost based optimizer OR is it wise to always use the cost based optimizer.
  2. If one uses the cost based optimizer and runs the "anlyze table table_name compute statistics" for all the table in the database periodically then is there any need to adjust the sequence of tables in the from statement to give hints to the optimizer which table to use as the driver.
Received on Fri Jul 04 1997 - 00:00:00 CDT

Original text of this message

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