All the Perl that's Practical to Extract and Report

Oracle SQL tuning

djberg96 on 2003-03-06T17:23:52

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?

Mastering Oracle SQL

jdavidb on 2003-03-06T19:41:19

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! :)

Interesting SQL article

runrig on 2003-03-06T22:03:16

DDJ had an interesting article 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).

Got one, have read the other

tinman on 2003-03-07T07:04:33

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 or Oracle tuning for some general tuning tips..