Query Tuning
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Query Tuning

  1. #1
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    Exclamation

    hi
    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)
    regards
    Cheers!
    OraKid.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Read Oracle Performance Tuning by Richard J. Niemiec.

  3. #3
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    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.


    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

  4. #4
    Join Date
    May 2000
    Posts
    58
    Highly recommend this book for some serious sql tuning.

    Oracle SQL - High Performance Tuning by Guy Harrison.
    Publisher : Printice Hall
    ISBN :0136142311

    No I dont work for Barnes and Noble )

  5. #5
    Join Date
    Aug 2001
    Posts
    111
    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
    Table partition/parallelism

    The golden rule is to only select the bare minimum from each i.e only what is required to give the resultant set.

    Have Fun


    Performance... Push the envelope!

  6. #6
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    ORACLE PL/SQL TIPS & TECHNIQUES
    by JOSEPTH C. TREZZO, BRADLEY D. BROWN, RICHARD NIEMEC

    Not just for developers, but for DBA's also.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width