Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: tips on SQL performance

    Does anyone have an article on how to obtain high performance by writing good SQL statements? Thanks.

  2. #2
    Join Date
    Sep 2003
    Location
    Assen, Nederland
    Posts
    55
    An article won't suffice....

    [1] Planning : http://download-west.oracle.com/docs...a96532/toc.htm

    [2] Perf. Tuning : http://download-west.oracle.com/docs...a96533/toc.htm

    [3] Perf. Tuning : http://download-west.oracle.com/docs...a96533/toc.htm

    [4] Perf. Tuning : http://download-west.oracle.com/docs...a96533/toc.htm

    [5] Tom Kyte : http://www.amazon.com/exec/obidos/tg...444953-2726440

    [6] More Tom Kyte : http://images.amazon.com/images/P/15...1.LZZZZZZZ.jpg

    [7] Cary Millsap : http://images.amazon.com/images/P/05...1.LZZZZZZZ.jpg

    [8] Jonathan Lewis : http://www.amazon.com/exec/obidos/tg...er#reader-link

    [9] Guy Harrison : http://www.amazon.com/exec/obidos/tg...er#reader-link

    Having read this/and using this as a solid reference material, you'll be thinking all the time from performance point of view.

    Cheers!
    Hope that helped...
    Visit My Website : http://www.oraflame.com
    _____________________________
    Tarry Singh

    OCP DBA 8i
    Currently: SQL Server DBA 7,2000
    Oracle, PHP Programmer

  3. #3
    Join Date
    Sep 2003
    Location
    Assen, Nederland
    Posts
    55
    There'e no typo there, if you know what I mean
    Hope that helped...
    Visit My Website : http://www.oraflame.com
    _____________________________
    Tarry Singh

    OCP DBA 8i
    Currently: SQL Server DBA 7,2000
    Oracle, PHP Programmer

Posting Permissions

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