Title Statements
- Full title :SQL tuning / Dan Tow.
Edition Statements
- Publication Date:2003.
- Edition:1st ed
Publication Statements
- Publisher(s):O'Reilly
- Place of Publication:Beijing
- Language:eng
- Publication Date:2003.
Notes
"Covers Oracle, DB2 & SQL server"--Cover.
"Generating optimal execution plans"--Cover.
Includes index.
The Physical Object
- Description:xix, 314 pages : : illustrations ; : 24 cm
Edition Identifiers
- ISBN:0596005733, 9780596005733
- oclc:ocm53460844
- LC Classification:QA76.73.S67
- Dewey Decimal:005.75/65
Table of Contents
1. Introduction -- 2. Data-Access Basics -- 3. Viewing and Interpreting Execution Plans -- 4. Controlling Execution Plans -- 5. Diagramming Simple SQL Queries -- 6. Deducing the Best Execution Plan -- 7. Diagramming and Tuning Complex SQL Queries -- 8. Why the Diagramming Method Works -- 9. Special Cases -- 10. Outside-the-Box Solutions to Seemingly Unsolvable Problems -- A. Exercise Solutions -- B. The Full Process, End to End.
Read More ↓
Rate & Review