SQL tuning

by Tow, Dan

Type Book

Rate 0.0 /5

Details

Files

Reviews

Download

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:1 online resource (xix, 314 pages) : : illustrations

Edition Identifiers

ISBN:9780596517410, 0596517416
oclc:ocn607017570
LC Classification:QA76.73.S67
Dewey Decimal:005.75/65

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.