|Pro Oracle SQL|
Authors: Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, Jared Stil
Karen Morton and her team combine good explanations of concepts with excellent knowledge of Oracle SQL, and the result is a book that is very understandable while explaining ideas such as execution plans and performance management so you really improve your SQL.
Morton is good on giving an overview idea, and chapters 4 and 5 both illustrate this. In Chapter 4 she discusses the fact that SQL is about sets, and how to move from procedural to set-based thinking. The different set operations, and the use of sets and nulls are both covered well.
The next few chapters cover subquery factoring, semijoins and autojoins, and the ‘other’ SQL commands such as Insert and Update. There’s a good chapter on transaction processing, after which Morton moves on to testing, quality assurance, plan stability, and plan control. The chapter on plan stability looks at the way Oracle’s Cost-Based Optimizer (CBO) changes execution plans in a seemingly random way, and the fact that such changes are not at all random. Morton shows how to avoid plan changes, and what to do to identify changes. The chapter on plan control continues this with looks at modifying query structures to avoid plan instability, and what you can do if you don’t have access to the problem code. The book ends with a look at miscellaneous SQL constructs such as Decode, Case, NullIf, Pivot queries, and using SQL to generate test data.
Reading the book and working through the examples should really improve your SQL. The key to getting the best out of Oracle is expert use of SQL execution plans, and this book gives you the tools to work with them.
|Last Updated ( Wednesday, 21 May 2014 )|