Home » RDBMS Server » Performance Tuning » query writing
query writing [message #467122] Thu, 22 July 2010 05:08 Go to next message
prashant_ora
Messages: 196
Registered: July 2010
Senior Member
can any one suggest me how to write the where clause means bind variable values comes first or join condition should come first or oracle 10g will adjust every thing if we put the where clause in any manners.

Report message to a moderator

Re: query writing [message #467124 is a reply to message #467122] Thu, 22 July 2010 05:09 Go to previous message
cookiemonster
Messages: 13921
Registered: September 2008
Location: Rainy Manchester
Senior Member
The CBO generally doesn't care about the order of the where clause.

Report message to a moderator

Previous Topic: Explain Plan Analysis - Execution ordering
Next Topic: INVISIBLE INDEX-11g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 04 08:40:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.