-
Good morning all,
I am looking for lists of guidelines or tips for writing efficient sql queries to help to increase application performance and query tunning, and the reasons of using them. These tips including using NOT EXISTS instead of NOT IN and never use NOT on an indexed column etc. If you have the lists, can you share with me? You can send them to wujee@yahoo.com. Or can you send me a link where I can find them?
Thanks
-
select executions, disk_reads, buffer_gets, sql_text from v$sql where disk_reads >100 order by disk_reads ;
take the sql statement which has the most disk reads..
try to get the execution path by using the explain plan ...
see whether the table
has indexes
how many rows
if there is index will it improve the performance ...
try doing it within days you will catch up ...
Radhakrishnan.M
-
If you have Metalink acess , pl search for SQL Tuning , you see very good documents ..
http://metalink.oracle.com/metalink/...1&blackframe=0
May be the above link will help you
Thanks,
Madhu
-
Read the performance and tuning manual.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
Thank you, thank you, thank you all!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|