Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

djberg96 (2603)

djberg96
  (email not shown publicly)

Journal of djberg96 (2603)

Thursday March 06, 2003
12:23 PM

Oracle SQL tuning

[ #10925 ]
That's it. I'm tired of hitting IO limits with Oracle SQL (both the stuff I write and the stuff others have written that I end up maintaining). So, today during lunch I'm going to buy the Oracle SQL Tuning Pocket Reference

That's just to tide me over until I either buy Mastering Oracle SQL or Oracle SQL - High Performance Tuning. I'll take a look at each one and decide which one I think is better.

Anyone out there have both that could comment?


List all Journal entries
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Oracle SQL tuning 3 Comments More | Login | Reply /

 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.

  • Mastering Oracle SQL (Score:3, Informative)

    by jdavidb (1361) on 2003.03.06 14:41 (#17776) Homepage Journal

    I just got Mastering Oracle SQL. It's a nice book, but I don't think it really focuses on tuning. It seems to be more concerned with features. I haven't really looked at it much, though, so there may be tuning advice throughout.

    Oracle Performance Tuning from O'Reilly has a section on tuning SQL. I got it for five bucks [75offbookstores.com]! :)

    --
    J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers
  • DDJ [ddj.com] had an interesting article [ddj.com] a while back on external SQL rewriters, which to me amounted to saying that when it comes to SQL, sometimes you just gotta try different things until it comes out better. I'm usually pretty good at SQL tuning, but there's no way I could manually brute force a better solution than a rewriter (at least not on a complex query like they have in the example).

  • Get Oracle Performance Tuning, if you really need to know some tricks on tuning.. Pity though, the last edition was published in 1996, quite a bit has changed since then (especially with the optimizers).. Some of their advice is still valid, (minimizing joins, exists, avoiding INs).. Mastering SQL is more about the neat features of Oracle SQL rather than tuning specifically,as jdavidb noted.. (a former co-worker had it, so I went through it a while back)

    You might also want to try Ixora scripts [ixora.com.au] or Oracle tu [oracletuning.com]

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.