Normal view MARC view ISBD view

Burleson, Donald K.

Oracle high-performance SQL tuning / Donald K. Burleson. - 1st ed. - Berkeley, Calif. : Osborne/McGraw-Hill, c2001. - xxvi, 575 p. : ill. ; 24 cm.

Includes index.
At head of title: Oracle Press.
"Covers Oracle database releases 7.x, 8, and 8i"--Cover.

1. Introduction to SQL --
2. Overview of Oracle SQL extensions --
3. Understanding SQL execution --
4. Overivewof the SQL optimizers --
5. SQL internal processing --
6. Tuning SQL table access --
7. The steps to Oracle SQL tuning --
8. Understanding Oracle SQL utilities --
9. Locating significant SQL statements --
10. Tuning full-table scans and parallel query --
11. Optimizing sorting for Oracle SQL statements --
12. Tuning with Oracle hints --
13. Tuning with optimizer plan stability --
14. Tuning with the cost-based optimizer --
15. Tuning with the rule-based optimizer --
16. Tuning table joins --
17. Tuning SQL DML statements --
18. Tuning SQL with temporary tables --
19. Tuning SQL subqueries --
20. Tuning SQL with indexes --
21. Tuning data warehouse SQL --
22. SQL tuning with STATSPACK --
23. Tuning SQL with built-in functions and special operators.

ISBN: 0072190582 9780072190588

Subjects--Topical Terms:
SQL (Computer program language)
Database management.
Relational databases.

LC Class. No.: QA76.9.D3 / .B87525