RE: new sql tuning book
- From: "Nelson, Allan" <anelson@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 9 Feb 2004 08:29:57 -0600
I'm reading it. The theory sounds good. It takes practice to do the
diagraming method he teaches so some time with real queries is
mandatory. You can, of course, get training classes from his website.
The most interesting idea, IMO, is the idea he presents of robust query
plans. His idea is that using a nested loops qep with the driving table
chosen from the most selective filter, then joining to the next table
with the next most selective filter and so on until all your joins are
accounted for is seductive in its simplicity.
In support of that idea, we moved, last year from Oracle Financials 10.7
character mode to 11i which took us from the rule based optimizer to the
cost based optimizer. A goodly number of queries degenerated in
response time and were "fixed" by adding a rule hint.
Of course, this email over simplifies the book and the author has more
to say than I have indicated here. One encouraging thing for me was
that he got his start query tuning working for Oracle tuning Financials.
Maybe not OPM though.
Allan
-----Original Message-----
=46rom: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Chris Stephens
Sent: Friday, February 06, 2004 4:21 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: new sql tuning book
Has anyone read the 'SQL Tuning Book' by Dan Tow from oreilly=3F It looks
to
be very good and I was thinking of picking it up.
=20
Any comments on the quality of the book would be much appreciated.
...after
this week, there is no doubt in my mind I need to improve my sql tuning
skillz!
=20
chris
=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
=46AQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
______________________________________________________________________________
This email is intended solely for the person or entity to which it is addressed
and may contain confidential and/or privileged information. Copying,
forwarding or distributing this message by persons or entities other than the
addressee is prohibited. If you have received this email in error, please
contact the sender immediately and delete the material from any computer. This
email may have been monitored for policy compliance. [021216]
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
