Items related to Oracle High-Performance SQL Tuning (DATABASE &...
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 (OReilly), 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
- Number of pages656
Buy New
Learn more about this copy
£ 39.47
Shipping:
£ 2.99
Within U.S.A.
Top Search Results from the AbeBooks Marketplace
Stock Image
Oracle High-Performance SQL Tuning
Seller: Zoom Books Company, Lynden, WA, U.S.A.
Seller rating 5 out of 5 stars
Condition: USED_GOOD. Book is in good condition and may contain underlining or highlighting and minimal wear. The book can also include library labels. May not contain miscellaneous items toys, dvds, etc . We offer 100% money back guarantee and fast customer support. Seller Inventory # 5AAWX7001CQ2_ns
Quantity: 1 available
Stock Image
Oracle High-Performance SQL Tuning
Seller: ThriftBooks-Phoenix, Phoenix, AZ, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: USED_GOOD. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 0.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: USED_GOOD. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 0.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: USED_VERYGOOD. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 0.75. Seller Inventory # G0072190582I4N00
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: USED_GOOD. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 0.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: USED_GOOD. No Jacket. Former library book; Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 0.75. Seller Inventory # G0072190582I3N10
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: USED_GOOD. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 0.75. Seller Inventory # G0072190582I3N00
Quantity: 1 available
Stock Image
Oracle High-Performance SQL Tuning
Seller: Goodwill, Brooklyn Park, MN, U.S.A.
Seller rating 5 out of 5 stars
Condition: UNSPECIFIED. Cover/Case has some rubbing and edgewear. Access codes, CDs, slipcovers and other accessories may not be included. Seller Inventory # 2Y6JCI008RX0_ns
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, Mishawaka, IN, U.S.A.
Seller rating 5 out of 5 stars
Condition: USED_GOOD. 1st Edition. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages. Seller Inventory # 8392566-6
Quantity: 1 available
Stock Image
Oracle High-Performance SQL Tuning
Seller: HPB-Red, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: USED_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