OraFAQ Forum: Performance Tuning » Rule for optimizing the query (merged)

Home » RDBMS Server » Performance Tuning » Rule for optimizing the query (merged)

Tue, 09 October 2007 22:28

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?

Tue, 09 October 2007 22:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Tue, 09 October 2007 22:52

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?

Tue, 09 October 2007 22:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Tue, 09 October 2007 23:00

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Rule 1. Do write good code.
Rule 2. Don't write bad code.

/forum/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

Previous Topic:	Performance Not Improved with Hint
Next Topic:	Different explain plan

Goto Forum:

]

Current Time: Tue Jun 25 20:39:30 CDT 2024