Home » RDBMS Server » Performance Tuning » Rule for optimizing the query (merged)
Rule for optimizing the query (merged) [message #273300] Tue, 09 October 2007 22:28 Go to next message
ashishmcajec
Messages: 20
Registered: April 2007
Location: Mumbai
Junior Member
I am very new for oracle so can anybody tell if i have a SQL query so how can i optimized that query and what are the rules of it?
Re: Optimizing the query [message #273302 is a reply to message #273300] Tue, 09 October 2007 22:32 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>http://www.orafaq.com/forum/t/84315/74940/
Rule for optimizing the query [message #273306 is a reply to message #273300] Tue, 09 October 2007 22:52 Go to previous messageGo to next message
ashishmcajec
Messages: 20
Registered: April 2007
Location: Mumbai
Junior Member
Can anybody tell me what are the basic rule for performance tunning of the SQL query?
Re: Rule for optimizing the query [message #273309 is a reply to message #273306] Tue, 09 October 2007 22:59 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
All the rules can be found here.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm
Re: Rule for optimizing the query [message #273310 is a reply to message #273306] Tue, 09 October 2007 23:00 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Rule 1. Do write good code.
Rule 2. Don't write bad code.

./fa/3204/0/

Seriously, three books on the subject over 500 pages. Do you reckon there's going to be a single rule?

Ross Leishman
  • Attachment: google.GIF
    (Size: 38.34KB, Downloaded 202 times)
Previous Topic: Performance Not Improved with Hint
Next Topic: Different explain plan
Goto Forum:
  


Current Time: Sat Dec 10 02:55:13 CST 2016

Total time taken to generate the page: 0.05668 seconds