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.

Report message to a moderator

Re: ORACLE OPTIMIZER [message #444740 is a reply to message #444737] Tue, 23 February 2010 22:14 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
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

Report message to a moderator

Previous Topic: Migration to Oracle 10 Performance issues
Next Topic: Restructering
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 14:11:37 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.