Synopsis
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.
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.
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 this title" may belong to another edition of this title.
Search results for Oracle High-Performance SQL Tuning (DATABASE &...
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: Good. 1st Edition. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Seller Inventory # 5314752-6
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. Seller Inventory # G0072190582I2N00
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. Seller Inventory # G0072190582I3N00
Stock Image
Oracle High-Performance SQL Tuning (DATABASE & ERP - OMG)
Seller: Sell Books, Elland, YORKS, United Kingdom
Seller rating 5 out of 5 stars
paperback. Condition: Good. Our good condition books are generally good for reading but not for gifting or collecting. They could have imperfections such as creasing, fanning, inscriptions, margin notes, yellowing, staining on edge or cover or pages, bumps, scuffs, etc etc (sometimes multiple of these). It's a wide category that encompasses anything that isn't almost-new down to anything that is slightly better than poor. We would NOT recommend gifting Good books - these should be considered reading copies. Our books are dispatched from a Yorkshire former cotton mill. We list via barcode/ISBN so please note that the images are stock images and may not be the exact copy you receive, furthermore the details about edition and year might not be accurate as many publishers reuse the same ISBN for multiple editions and as we simply scan a barcode or enter an ISBN we do not check the validity of the edition data when listing. If you're looking for an exact edition please don't order (at least not without checking with us first, although we don't always have time to check). We aim to dispatch prompty, the service used will depend on order value and book size. We can ship to most countries, see our shipping policies. Payment is via Abe only. Seller Inventory # mon0000046987
Buy Used
£ 29.48
£ 12.15 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 1 available
Stock Image
Oracle High-Performance SQL Tuning
Seller: Lucky's Textbooks, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # ABLIING23Feb2215580015117
Seller Image
Oracle High-Performance SQL Tuning
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 494884-n
Seller Image
Oracle High-Performance SQL Tuning
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: As New. Unread book in perfect condition. Seller Inventory # 494884
Seller Image
Oracle High-Performance SQL Tuning
Seller: GreatBookPricesUK, Woodford Green, United Kingdom
Seller rating 5 out of 5 stars
Condition: As New. Unread book in perfect condition. Seller Inventory # 494884
Buy Used
£ 61.94
£ 15 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: Over 20 available
Stock Image
Oracle High-Performance SQL Tuning
Print on DemandSeller: Majestic Books, Hounslow, United Kingdom
Seller rating 4 out of 5 stars
Condition: New. Print on Demand pp. xxvi + 575 Illus. Seller Inventory # 4219659
Buy New
£ 84.67
£ 6.50 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 4 available
Stock Image
Oracle High-Performance SQL Tuning
Published by
McGraw-Hill Education - Europe, 2001
ISBN 10: 0072190582
ISBN 13: 9780072190588
New
Paperback / softback
Seller: THE SAINT BOOKSTORE, Southport, United Kingdom
Seller rating 5 out of 5 stars
Paperback / softback. Condition: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days. Seller Inventory # C9780072190588
Buy New
£ 71.06
£ 23.40 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: Over 20 available