Results 1 to 2 of 2

Thread: Recommend an Oracle query optimisation book or course

  1. #1
    Senior Member manwithnoname's Avatar
    Join Date
    Dec 2005
    26 times in 25 posts

    Recommend an Oracle query optimisation book or course

    Can anyone recommend a book on oracle query optimisation and/or recommend a course?

    Bit of background:

    This year's task is to optimisation a few oracle SQL reports - ok may be a couple of hundred.

    I can see obvious optimisations, but there are some reports that are slow and I need to work out it that are just slow or if it is the 'query execution plan' for them than is none to clever. So I need to understand oracle's EXPLAIN PLAN output.

    Currently using oracle 8 but will be moving to 9 or 10 later this year it that makes any difference.


  2. #2
    Join Date
    Sep 2003
    1 time in 1 post
    all the 9i docs..

    and the how to use EXPLAIN PLAN bit:

    these are all for 9i release 2 which is the earliest version of Orable that you should be using in a production enviroment imho. (even though we are still using 7.3.3 and 8.1.7 )

    shout of you have any questions not answered in the docs


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Recommend a book - SciFi only
    By IBM in forum General Discussion
    Replies: 38
    Last Post: 29-11-2006, 12:07 PM
  2. RMA Query
    By billythewiz in forum
    Replies: 7
    Last Post: 07-11-2006, 05:44 PM
  3. Learning SQl - oracle download?
    By PanzerKnight in forum Software
    Replies: 13
    Last Post: 29-07-2004, 07:11 PM

Posting Permissions

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