Oracle High-Performance SQL Tuning (Oracle Press Series)

4.33 avg rating
( 6 ratings by GoodReads )
 
9780072190588: Oracle High-Performance SQL Tuning (Oracle Press Series)

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.

"synopsis" may belong to another edition of this title.

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

About the Author:

Don Burleson (Kittrell, NC) has 20 years of experience as a database administrator and has written 9 books on database management including Oracle SAP Administration (O¿Reilly), High-Performance Oracle8 Tuning, High-Performance Oracle Data Warehousing, High-Performance Oracle Database Applications (Coriolis) and Oracle8 Tuning, German Edition (Sybex). Don has taught more than 100 University courses and regularly conducts in-house Oracle training.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Burleson, Donald K.
Published by McGraw-Hill Education
ISBN 10: 0072190582 ISBN 13: 9780072190588
New PAPERBACK Quantity Available: 1
Seller
glenthebookseller
(Montgomery, IL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Book Condition: New. 0072190582 Brand new, Never used!. Bookseller Inventory # Z0072190582ZN

More Information About This Seller | Ask Bookseller a Question

Buy New
25.03
Convert Currency

Add to Basket

Shipping: 2.43
Within U.S.A.
Destination, Rates & Speeds

2.

Burleson, Donald K.
Published by McGraw-Hill Education (2001)
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Quantity Available: > 20
Print on Demand
Seller
PBShop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2001. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # IQ-9780072190588

More Information About This Seller | Ask Bookseller a Question

Buy New
32.85
Convert Currency

Add to Basket

Shipping: 3.23
Within U.S.A.
Destination, Rates & Speeds

3.

Burleson, Donald K.
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Paperback Quantity Available: > 20
Print on Demand
Seller
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. This item is printed on demand. Item doesn't include CD/DVD. Bookseller Inventory # 1103818

More Information About This Seller | Ask Bookseller a Question

Buy New
33.37
Convert Currency

Add to Basket

Shipping: 3.23
Within U.S.A.
Destination, Rates & Speeds

4.

Burleson, Donald K.
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Quantity Available: 5
Seller
Chiron Media
(Wallingford, United Kingdom)
Rating
[?]

Book Description Book Condition: New. Brand new book, sourced directly from publisher. Dispatch time is 24-48 hours from our warehouse. Book will be sent in robust, secure packaging to ensure it reaches you securely. Bookseller Inventory # NU-ING-00005764

More Information About This Seller | Ask Bookseller a Question

Buy New
36.34
Convert Currency

Add to Basket

Shipping: 2.99
From United Kingdom to U.S.A.
Destination, Rates & Speeds

5.

Burleson, Donald K.
Published by McGraw-Hill Osborne Media
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Paperback Quantity Available: 20
Print on Demand
Seller
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media. Paperback. Book Condition: New. This item is printed on demand. Paperback. 656 pages. 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. Youll get details on Oracles optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements. This item ships from La Vergne,TN. Paperback. Bookseller Inventory # 9780072190588

More Information About This Seller | Ask Bookseller a Question

Buy New
36.46
Convert Currency

Add to Basket

Shipping: 3.20
Within U.S.A.
Destination, Rates & Speeds

6.

Burleson, Donald K.
Published by McGraw-Hill Osborne Media (2001)
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2001. Paperback. Book Condition: New. 1. Bookseller Inventory # DADAX0072190582

More Information About This Seller | Ask Bookseller a Question

Buy New
36.73
Convert Currency

Add to Basket

Shipping: 3.23
Within U.S.A.
Destination, Rates & Speeds

7.

Burleson, Donald K.
Published by McGraw-Hill Education (2001)
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Quantity Available: > 20
Print on Demand
Seller
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education, 2001. PAP. Book Condition: New. New Book. Delivered from our UK warehouse in 3 to 5 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # IQ-9780072190588

More Information About This Seller | Ask Bookseller a Question

Buy New
31.56
Convert Currency

Add to Basket

Shipping: 9
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

Burleson, Donald K.
Published by McGraw-Hill Osborne Media (2001)
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Softcover Quantity Available: 1
Seller
Book Deals
(Lewiston, NY, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2001. Book Condition: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: PART I Background 1 Introduction to SQL 2 Overview of Oracle SQL Extensions 3 Understanding SQL Execution 4 Overview of the SQL Optimizers 5 SQL Internal Processing 6 Tuning SQL Table Access PART II Basic SQL Tuning 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 PART III Advanced SQL Tuning 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 Index PART I Background 1 Introduction to SQL 2 Overview of Oracle SQL Extensions 3 Understanding SQL Execution 4 Overview of the SQL Optimizers 5 SQL Internal Processing 6 Tuning SQL Table Access PART II Basic SQL Tuning 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 PART III Advanced SQL Tuning 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. Bookseller Inventory # ABE_book_new_0072190582

More Information About This Seller | Ask Bookseller a Question

Buy New
41.11
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

9.

Burleson, Donald K.
Published by McGraw-Hill Osborne Media (2001)
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2001. Paperback. Book Condition: New. book. Bookseller Inventory # 0072190582

More Information About This Seller | Ask Bookseller a Question

Buy New
41.13
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

10.

Burleson, Donald K.
Published by McGraw-Hill Education (2001)
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Paperback Quantity Available: 10
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2001. Paperback. Book Condition: New. Bookseller Inventory # INGM9780072190588

More Information About This Seller | Ask Bookseller a Question

Buy New
43.11
Convert Currency

Add to Basket

Shipping: 3.23
Within U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book