Oracle high-performance SQL tuning / Donald K. Burleson.
Material type:
TextPublication details: Berkeley, Calif. : Osborne/McGraw-Hill, c2001.Edition: 1st edDescription: xxvi, 575 p. : ill. ; 24 cmISBN: - 0072190582
- 9780072190588
- QA76.9.D3 .B87525
| Cover image | Item type | Current library | Home library | Collection | Shelving location | Call number | Materials specified | Vol info | URL | Copy number | Status | Notes | Date due | Barcode | Item holds | Item hold queue priority | Course reserves | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Books
|
Methodist University Library Main General Stacks | Reference | QA76.9.D3 .B87525 (Browse shelf(Opens below)) | Available | 29173 |
Browsing Methodist University Library Main shelves,Shelving location: General Stacks,Collection: Reference Close shelf browser (Hides shelf browser)
|
|
|
|
|
|
|
||
| QA76.9.D3 .A92 Distributed databases, cooperative processing, and networking / | QA76.9.D3 .A985 Database management / | QA76.9.D3 .Ar5 Oracle discoverer 10g handbook / | QA76.9.D3 .B87525 Oracle high-performance SQL tuning / | QA76.9.D3 .C11 Succeeding in business with Microsoft Office Access 2007 : | QA76.9.D3 .El6 Fundamentals of database systems / | QA76.9.D3 .H83 Business Objects XI : |
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.
There are no comments on this title.