Home » RDBMS Server » Performance Tuning » ORACLE OPTIMIZER (Oracle 9.2, Windows)
icon14.gif  ORACLE OPTIMIZER [message #444737] Tue, 23 February 2010 21:55 Go to next message
visuorac
Messages: 10
Registered: February 2010
Location: chennai
Junior Member
Hi,

What is the difference between Rule based Optimizer and Cost based Optimizer in oracle? Please explain with example.
Re: ORACLE OPTIMIZER [message #444740 is a reply to message #444737] Tue, 23 February 2010 22:14 Go to previous message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
http://www.lmgtfy.com/?q=difference+between+Rule+based+Optimizer+and+Cost+based+Optimizer+in+oracle

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Posting Guidelines includes SEARCH & GOOGLE before posting
Previous Topic: Migration to Oracle 10 Performance issues
Next Topic: Restructering
Goto Forum:
  


Current Time: Mon Sep 26 09:23:56 CDT 2016

Total time taken to generate the page: 0.28067 seconds