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

Thread: Query Tuning

  1. 10-24-2001, 05:29 AM #1
    balajiyes
    balajiyes is offline Advisor
    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.
    Reply With Quote Reply With Quote
  2. 10-24-2001, 03:20 PM #2
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Read Oracle Performance Tuning by Richard J. Niemiec.
    Reply With Quote Reply With Quote
  3. 10-29-2001, 08:07 PM #3
    chrisrlong's Avatar
    chrisrlong
    chrisrlong is offline
    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
    Reply With Quote Reply With Quote
  4. 10-29-2001, 09:06 PM #4
    Victoria
    Victoria is offline Junior Member
    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 )
    Reply With Quote Reply With Quote
  5. 10-30-2001, 02:20 AM #5
    roobaron
    roobaron is offline Member
    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!
    Reply With Quote Reply With Quote
  6. 10-30-2001, 02:56 AM #6
    reydp's Avatar
    reydp
    reydp is offline Senior Advisor
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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