search for books and compare prices
By
Kevin Meade
Price
Store
Arrives
Preparing
Shipping
Jump quickly to results on these stores:
The price is the lowest for any condition, which may be new or used; other conditions may also be available.
Jump down to see edition details for: Paperback
Bibliographic Detail
Publisher
Createspace Independent Pub
Publication date
September 16, 2014
Pages
556
Binding
Paperback
Book category
Adult Non-Fiction
ISBN-13
9781501022692
ISBN-10
1501022695
Dimensions
1.50 by 7.75 by 9.50 in.
Weight
2.40 lbs.
Original list price
$38.99
Amazon.com says people who bought this book also bought:
AWS Certified Solutions Architect Official Study Guide: Associate Exam | Oracle Database 12c Release 2 Performance Tuning Tips & Techniques | Oracle Database 11g Release 2 Performance Tuning Tips & Techniques | Expert Oracle Database Architecture | Troubleshooting Oracle Performance | Oracle Core | Cost-based Oracle Fundamentals
AWS Certified Solutions Architect Official Study Guide: Associate Exam | Oracle Database 12c Release 2 Performance Tuning Tips & Techniques | Oracle Database 11g Release 2 Performance Tuning Tips & Techniques | Expert Oracle Database Architecture | Troubleshooting Oracle Performance | Oracle Core | Cost-based Oracle Fundamentals
Summaries and Reviews
Amazon.com description: Product Description: Written by a Senior Database Administrator who has worked with the Oracle RDBMS for thirty years, this is a book which teaches the skill of SQL Tuning for the Oracle Database. Not a list of one-off tricks or tips, nor a glossing over of topics; this book offers an in-depth process covering discovery, analysis, and problem resolution. Learn the science behind SQL Tuning.
- Learn and apply the FILTERED ROWS PERCENTAGE Cardinality based method of tuning
- Determine a query's Driving Table and Join Order
- Construct Query Diagrams, Data Models, and Join Trees
- Build and use Count / Filter / and Reconstruction Queries
- Identify Waste in a Query Execution Plan
- Zero in on Cardinality Divergence using Estimated vs. Actuals
- Use the ACCESS / FILTER / COVERAGE strategy to build indexes for Problem Queries
- Exploit THE 2% RULE in analyzing Access method and Join method
- Classify queries as Precision Style or Warehouse Style
- Understand Hash Join mechanics and make Hash Joins go faster
- Make HINTS work as Detection Tools rather than clubs
- Avoid early Database Design flaws
- Manage Statistics and deal with common Statistics problems
- (NDV, Uniform Distribution, Independence, Dynamic Sampling)
- (Staleness, Skew, Dependence, Defaulting, Out-Of-Bounds, Transiency, Bloat)
- Perfect your Question Based Analysis Technique
- and more
- Chapter 1: DRIVING TABLE and JOIN ORDER
- Chapter 2: Ways to Use a Query Execution Plan
- Chapter 3: The Best Indexes for a Query
- Chapter 4: JOINS
- Chapter 5: HINTS
- Chapter 6: BASICS
- Chapter 7: ROW COUNTS and RUN TIMES
- Chapter 8: EXADATA
- LAB: Reverse Engineering the QEP
- Appendix: Know Your Scripts
- Scripts for analyzing queries and plans
- Scripts for examining an active database
- Scripts for looking at metadata
- showplan
- showplanshort
- showplanconstraints
- showplancountqueries
- showplandatamodel
- showplandrivingtable
- showplanfilterqueries
- showplanfrpspreadsheetcode
- showplanindexes
- showplannumrows
- showplanquerydiagram
- showplantables
- showplantablesunique
- loadplanfromcache
- loadplanfromhist
- showtopcpu
- showowner
- showindexes
- showconstraints
- showcolstats
- showhistograms
- showallscanrates
- showallworkareas
Editions
Paperback
The price comparison is for this edition
from Createspace Independent Pub (September 16, 2014)
9781501022692 | details & prices | 556 pages | 7.75 × 9.50 × 1.50 in. | 2.40 lbs | List price $38.99
About: Written by a Senior Database Administrator who has worked with the Oracle RDBMS for thirty years, this is a book which teaches the skill of SQL Tuning for the Oracle Database.
About: Written by a Senior Database Administrator who has worked with the Oracle RDBMS for thirty years, this is a book which teaches the skill of SQL Tuning for the Oracle Database.
Pricing is shown for items sent to or within the U.S., excluding shipping and tax. Please consult the store to determine exact fees. No warranties are made express or implied about the accuracy, timeliness, merit, or value of the information provided. Information subject to change without notice. isbn.nu is not a bookseller, just an information source.