Oracle SQL Tuning Pocket Reference (Anglais) Broché – 5 décembre 2001
|Neuf à partir de||Occasion à partir de|
Les clients ayant acheté cet article ont également acheté
Descriptions du produit
Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.
Pour obtenir l'appli gratuite, saisissez votre adresse e-mail ou numéro de téléphone mobile.
Détails sur le produit
En savoir plus sur l'auteur
Dans ce livre(En savoir plus)
Commentaires en ligne
Meilleurs commentaires des clients
Commentaires client les plus utiles sur Amazon.com (beta)
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.
As to the rest, there are 22 pages (out of merely 102) enumerating the many hints one can apply to SQL. There's not much here that isn't already available from Oracle documentation directly.
* 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.