| tuning question [message #116364] |
Tue, 19 April 2005 11:55  |
 |
Bruce Carson
Messages: 38
Registered: February 2005
Location: Nova Scotia, Canada
|
Member |
|
|
sql tuning
What would be the top 5 tuning techniques when using sql?
|
|
|
|
| Re: tuning question [message #116367 is a reply to message #116364] |
Tue, 19 April 2005 12:22  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
1. Read the Oracle Concepts Guide
2. Read the Oracle Application Developer Fundamentals Guide
3. Read the Performance Tuning Guide
4. Make sure you are using the latest Oracle Release Version
5. Read Effective Oracle By Design by Tom Kyte
|
|
|
|
|
|
| Re: tuning question [message #116401 is a reply to message #116364] |
Tue, 19 April 2005 17:02 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Yeah, I wish I could read a lot faster myself...
Actually a couple quick general things might be:
a) use sql instead of plsql whenever possible
b) use analytic functions
c) use inline views
d) try more than one method and test their plans/stats
e) think about the queries you need to run when creating your tables in the first place
[Updated on: Tue, 19 April 2005 17:03] Report message to a moderator |
|
|
|
| Re: tuning question [message #116524 is a reply to message #116401] |
Wed, 20 April 2005 09:02 |
pscjhe
Messages: 38
Registered: April 2005
|
Member |
|
|
As to "Tuning SQL" my top 5 would be
1. Understand what this SQL wants to do
2. Understand physical objects underlying SQL
Particularly indexes, statistics
3. Understand what each version of Oracle can offer
Particularly the improvements in Optimizer (CBO), SQL,
indexes.
4. Use explain plan, autotrace, tkprof and runstats to compare
Different execution plan's and its runtime statistics
5. Cheat (:-
asktom.oracle.com
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
