<< 1 >>
Rating: 
Summary: Essential guide for tuning Oracle SQL
Review: This is the best book I've seen for tuning Oracle SQL.
It is well written, up to date (includes 9i info), and full of examples and real world experiences. All packed into 100 little pages!
Many of the Oracle books I've purchased (especially the tuning references) are just sitting on the shelf collecting dust. They're too big, and filled with a lot of 'dead weight'. I've already read this pocket reference twice (it's suprising how much more of it 'sticks' the second time around) and gathered more useful knowledge than all my other sql tuning books combined.
I know this is called a pocket reference simply because of it's size, but it's really more of an instructional manual than just a reference.
Every Oracle developer and DBA should read this book ...at least twice.
Rating:
Summary: Worths to own one!
Review: Yesterday, I saw this pocket book, then I decide to buy it because...
* Clear clarification on which optimizer (cost-based and rule- based) is used for a specific situation and its problems.
* Sorts, indexes, IN/EXISTS, OR/UNION, Loop, joins with tables...etc related performance issues and rating , giving a reader a reminder on the criteria to write a well-performed SQL.
* What is bad SQL?How to use SQL Hints?
* How to analyze table with DBMS_STATS package?
* How to pre-define outline for your execution plan ?I have bought DBA checklist and Oracle with UNIX, they are my nice partners as well. Haha...I still remember I deal with a staging database problem in my work, I cannot find a solution from a THICK and HEAVY book but from them. If you need handy guides, pocket references are excellent and light, haha...I want to buy RMAN reference later :D, they seem a series of fiction.
<< 1 >>
| 
