I didn't notice that this pocket reference was still in its first printing, from January of 2002. As such most of the content is now obsolete. Specifically the author devotes a lot of space to comparing the Rule-Based and Cost-Based Optimizers, and points out the clear superiority of the latter.
Oracle SQL tuning: pocket reference
โ Scribed by Mark Gurry
- Publisher
- O'Reilly & Associates
- Year
- 2002
- Tongue
- English
- Leaves
- 90
- Edition
- 1st ed
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
I didn't notice that this pocket reference was still in its first printing, from January of 2002. As such most of the content is now obsolete. Specifically the author devotes a lot of space to comparing the Rule-Based and Cost-Based Optimizers, and points out the clear superiority of the latter. This was big news when Oracle 9i was about to be released, not so much now.
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.
๐ SIMILAR VOLUMES
One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of m
One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements