Oracle High-Performance SQL Tuning

Oracle High-Performance SQL Tuning

Editorial Reviews
Book Description
From the official Oracle Press comes a comprehensive guide to tuning SQL statements for optimal execution. This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.

From the Back Cover

Improve Database Performance by Tuning SQL Statements

Tune all types of SQL statements--from a simple SELECT statement to a complex non-correlated subquery--using tips and techniques from SQL expert Don Burleson. Officially authorized by Oracle Corporation, this in-depth resource explains how to take any SQL statement, view the internal execution plan, and change the execution plan to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.

• Understand how SQL tuning fits into the overall Oracle tuning model
• Improve Oracle SQL functionality using extensions such as in-line views and BIFs
• Identify and report on SQL in the library cache
• Tune SQL table access, full-table scans, and parallel query
• Run TKPROF to get a SQL trace report
• Change the execution plans for Oracle SQL statements using Oracle hints
• Use the Oracle8i optimizer plan stability, cost-based optimizer, and rule-based optimizer
• Tune SQL DML statements, SQL subqueries, and data warehouse SQL
• Tune SQL with temporary tables and indexes
• Diagnose and optimize system performance using STATSPACK

Oracle High-Performance SQL Tuning,Donald K. Burleson,McGraw-Hill Osborne Media,0072190582,Certification Guides - General,Computer Books: Database,Computers,Computers - Data Base Management,Database Management - General,Database Management - Oracle,Database management,Oracle (Computer file),Programming Languages - SQL,Relational Databases,SQL (Computer program language,SQL (Computer program language),Sql (Programming Language),Computers / Technical Skills,Oracle,SQL

Hot Books:

1. Organisational Management: May 2002 Exam Questions & Answers (CIMA Q&A)
2. PC Magazine Fighting Spyware, Viruses, and Malware
3. Photoshop CS Killer Tips (Killer Tips)
4. Practical Intranet Development
5. Professional Design Patterns in VB .NET: Building Adaptable Applications
6. Professional Palm OS ® Programming (Wrox Professional Guides)
7. Professional SQL Server 2000 DTS (Data Transformation Services) (Programmer to Programmer)
8. Programming Microsoft ADO.NET 2.0 Core Reference
9. Programming Visual Basic .NET, 2nd Edition
10. Programming with Qt (2nd Edition)

Hot Books

Recommended Books

1. Functional Pottery: Form and Aesthetic in Pots of Purpose
2. Strontium Dog: Portrait of a Mutant
3. A Feminist Reader in Early Cinema
4. Apple Pro Training Series : DVD Studio Pro 3
5. Appreciative Intelligence : Seeing the Mighty Oak in the Acorn
6. A Decade of Hubble Space Telescope Science
7. Advances in Chemical Physics, Electron Transfer—From Isolated Molecules to Biomolecules, P
8. Advances In Laser Physics
9. A Dark Night Hidden
10. A History of the World's Religions
11. American & British 410 Shotguns
12. Adding Space Without Adding on
13. Airborne Early Warning System Concepts
14. African Birds
15. Amsterdam Made Easy: The Best Sights and Walks of Amsterdam