can anyone give a good website for purfomance tuning & best way of writing a SQL Query for a VERY LARGE DATABASE.
say linking 4 tables (record per table minimum of 60lakhs)
Read Oracle Performance Tuning by Richard J. Niemiec.
The information in that book is terribly out-dated, reflecting a rather old-school approach to tuning (stemming from the days of RULE-based optimization). He definitely does not seem to have a grasp of more modern tuning techniques - at least from the SQL side of the house. All IMHO, of course.
Highly recommend this book for some serious sql tuning.
Oracle SQL - High Performance Tuning by Guy Harrison.
Publisher : Printice Hall
No I dont work for Barnes and Noble )
How about the online doco (Tuning and concepts)
Another good website is http://www.ixora.com.au website by Steve Adams, has links to others
Joining for 4 tables:
Look at index selectivity/cardinality
The golden rule is to only select the bare minimum from each i.e only what is required to give the resultant set.
Performance... Push the envelope!
ORACLE PL/SQL TIPS & TECHNIQUES
by JOSEPTH C. TREZZO, BRADLEY D. BROWN, RICHARD NIEMEC
Not just for developers, but for DBA's also.
Click Here to Expand Forum to Full Width