Oracle High-Performance SQL Tuning - Softcover

9780072190588: Oracle High-Performance SQL Tuning
View all copies of this ISBN edition:
 
 
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


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.

  • PublisherMcGraw Hill
  • Publication date2001
  • ISBN 10 0072190582
  • ISBN 13 9780072190588
  • BindingPaperback
  • Edition number1
  • Number of pages656
  • Rating

Top Search Results from the AbeBooks Marketplace

Stock Image

Burleson, Donald
Published by McGraw-Hill Education (2001)
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Softcover Quantity: > 20
Seller:
Lakeside Books
(Benton Harbor, MI, U.S.A.)

Book Description Condition: New. Brand New! Not Overstocks or Low Quality Book Club Editions! Direct From the Publisher! We're not a giant, faceless warehouse organization! We're a small town bookstore that loves books and loves it's customers! Buy from Lakeside Books!. Seller Inventory # OTF-S-9780072190588

More information about this seller | Contact seller

Buy New
US$ 51.32
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds
Seller Image

Burleson, Donald
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Paperback or Softback Quantity: 5
Seller:
BargainBookStores
(Grand Rapids, MI, U.S.A.)

Book Description Paperback or Softback. Condition: New. Oracle High-Performance SQL Tuning 2.2. Book. Seller Inventory # BBS-9780072190588

More information about this seller | Contact seller

Buy New
US$ 55.94
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds
Stock Image

Burleson, Donald K.
Published by McGraw Hill (2001)
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Softcover Quantity: > 20
Seller:
Lucky's Textbooks
(Dallas, TX, U.S.A.)

Book Description Condition: New. Seller Inventory # ABLIING23Feb2215580015117

More information about this seller | Contact seller

Buy New
US$ 56.25
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds
Stock Image

Burleson, Donald K.
Published by McGraw Hill (2001)
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Softcover Quantity: > 20
Seller:
California Books
(Miami, FL, U.S.A.)

Book Description Condition: New. Seller Inventory # I-9780072190588

More information about this seller | Contact seller

Buy New
US$ 69.00
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds
Stock Image

Donald K. Burleson
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Paperback / softback Quantity: > 20
Seller:
THE SAINT BOOKSTORE
(Southport, United Kingdom)

Book Description Paperback / softback. Condition: New. New copy - Usually dispatched within 4 working days. Seller Inventory # B9780072190588

More information about this seller | Contact seller

Buy New
US$ 74.79
Convert currency

Add to Basket

Shipping: US$ 11.40
From United Kingdom to U.S.A.
Destination, rates & speeds
Stock Image

Burleson, Donald K.
Published by McGraw Hill (2001)
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Softcover Quantity: 1
Seller:
BennettBooksLtd
(North Las Vegas, NV, U.S.A.)

Book Description Condition: New. New. In shrink wrap. Looks like an interesting title! 2.8. Seller Inventory # Q-0072190582

More information about this seller | Contact seller

Buy New
US$ 80.71
Convert currency

Add to Basket

Shipping: US$ 6.20
Within U.S.A.
Destination, rates & speeds
Stock Image

Donald K. Burleson
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Paperback / softback Quantity: > 20
Print on Demand
Seller:
THE SAINT BOOKSTORE
(Southport, United Kingdom)

Book Description Paperback / softback. Condition: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days. Seller Inventory # C9780072190588

More information about this seller | Contact seller

Buy New
US$ 78.98
Convert currency

Add to Basket

Shipping: US$ 11.40
From United Kingdom to U.S.A.
Destination, rates & speeds
Seller Image

Burleson, Donald
Published by MCGRAW HILL BOOK CO (2001)
ISBN 10: 0072190582 ISBN 13: 9780072190588
New Softcover Quantity: > 20
Seller:
moluna
(Greven, Germany)

Book Description Condition: New. &Uumlber den AutorDon Burleson (Kittrell, NC) has 20 years of experience as a database administrator and has written 9 books on database management including Oracle SAP Administration (OReilly), High-Performance Oracle8 Tuning, High-Pe. Seller Inventory # 897381188

More information about this seller | Contact seller

Buy New
US$ 74.33
Convert currency

Add to Basket

Shipping: US$ 53.15
From Germany to U.S.A.
Destination, rates & speeds