Items related to Oracle High-Performance SQL Tuning
Synopsis
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
- LanguageEnglish
- Edition number1
- Number of pages605
- Rating
Search results for Oracle High-Performance SQL Tuning
Stock Image
Oracle High-Performance SQL Tuning
Seller: HPB-Red, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_243699981
Quantity: 1 available
Stock Image
Oracle High-Performance SQL Tuning
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. Former library book; May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 2.75. Seller Inventory # G0072190582I4N10
Quantity: 1 available
Stock Image
Oracle High-Performance SQL Tuning
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 2.75. Seller Inventory # G0072190582I3N00
Quantity: 1 available
Stock Image
Oracle High-Performance SQL Tuning
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 2.75. Seller Inventory # G0072190582I4N00
Quantity: 1 available
Stock Image
Oracle High-Performance SQL Tuning
Seller: ThriftBooks-Reno, Reno, NV, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 2.75. Seller Inventory # G0072190582I3N00
Quantity: 1 available
Stock Image
Oracle High-Performance SQL Tuning
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 2.75. Seller Inventory # G0072190582I3N00
Quantity: 1 available
Stock Image
Oracle High-Performance SQL Tuning
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: As New. No Jacket. Pages are clean and are not marred by notes or folds of any kind. ~ ThriftBooks: Read More, Spend Less 2.75. Seller Inventory # G0072190582I2N00
Quantity: 1 available
Stock Image
Oracle High-Performance SQL Tuning
Published by
McGraw-Hill Education, 2001
ISBN 10: 0072190582
ISBN 13: 9780072190588
Used
Softcover
First Edition
Seller: Better World Books: West, Reno, NV, U.S.A.
Seller rating 5 out of 5 stars
Condition: Very Good. 1st Edition. Used book that is in excellent condition. May show signs of wear or have minor defects. Seller Inventory # 6350630-75
Quantity: 1 available
Stock Image
Oracle High-Performance SQL Tuning (DATABASE & ERP - OMG)
Seller: WorldofBooks, Goring-By-Sea, WS, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Seller Inventory # GOR005313579
Quantity: 1 available
Seller Image
Oracle High-Performance SQL Tuning (Paperback or Softback)
Published by
McGraw-Hill Companies 8/17/2001, 2001
ISBN 10: 0072190582
ISBN 13: 9780072190588
New
Paperback or Softback
Seller: BargainBookStores, Grand Rapids, MI, U.S.A.
Seller rating 5 out of 5 stars
Paperback or Softback. Condition: New. Oracle High-Performance SQL Tuning 2.2. Book. Seller Inventory # BBS-9780072190588
Quantity: 5 available