Hi,
I have couple of questions about oracle optimization.
- 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.
- 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