Title: Oracle SQL Performance Tuning and Optimization : It's All About the Cardinalities
Publisher: CreateSpace Independent Publishing Platform
Publication Date: 2014
Language: English
ISBN 10: 1501022695
ISBN 13: 9781501022692
Binding: Soft cover
Condition: New

About this title

Synopsis

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 Analyis Technique
and more

Included are: a special chapter for EXADATA, a LAB which demonstrates the cardinality based process of SQL Tuning, and twenty three magical SQL scripts that make the process of SQL Tuning easy to do. Learn the skill of SQL Tuning as taught by an expert who does it for a living, and become the go-to specialist in your company.

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

It’s all about the Cardinalities

"About this title" may belong to another edition of this title.

Store Description

GreatBookPrices.com is your top source for finding new books at the absolute lowest prices, guaranteed ! We offer big discounts - everyday - on millions of titles in virtually any category, from Architecture to Zoology -- and everything in between. Discover great deals and super-savings, on professional books, text book titles, the newest computer guides, or your favorite fiction authors. You'll find it all - at HUGE SAVINGS - at GreatBookPrices. Browse through our complete online product catalog today. Serving customers around the world for years, we help thousands find just the books they're looking for -- at incredibly low, bargain prices.

Visit Seller's Storefront

Seller's business information

Far Corner Europe Limited
19-20 Bourne Court, 19-20 Bourne Court, Woodford Green, IG8 8HD, United Kingdom

Sale & Shipping Terms

Terms of Sale

Company Name: GreatBookPricesUK
Legal Entity: Far Corner Europe Limited
Address: 19-20 Bourne Court, Southend Road, Woodford Green Essex, UK IG8 8HD
Registration #: 10691061
Authorized representative: Danielle Hainsey

Shipping Terms

Our warehouses across the globe are fully operational without substantial delays. We are working hard and continue to overcome the daily challenges presented by COVID-19. There have been reports that delivery carriers are experiencing large delays resulting in longer than normal deliveries to customers. See USPS's website for further detail. We would like to apologize in advance if your item arrives later than the expected delivery due date.

Internal processing of your order will take about 1-2 business days. Please allow an additional 4-14 business days for Media Mail delivery. We have multiple ship-from locations - MD,IL,NJ,UK,IN,NV,TN & GA

Shipping rates from United Kingdom to U.S.A.

Shipping rates from United Kingdom to U.S.A.
Order quantity	10 to 30 business days	10 to 27 business days
First item	US$ 20.07	US$ 20.07

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.