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: paperback
Condition: Good

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

About Us: Coas Books is New Mexico?s largest second-hand bookstore with more than 500,000 books in stock! We have an incredible selection of new and used books ? including regional and out-of-print books ?, CDs, DVDs, Vinyl, VHS, audio books, and games. Coas Books is family owned and operated, with two stores located in Las Cruces, New Mexico. We receive hundreds of books every day, so our inventory is constantly changing and full of hidden gems! Our History: Coas Books was founded in 1983 by archaeologist Pat Beckett. It started out as an archaeological publishing company specializing in anthropology books. As Pat's vast collection of books continued to grow, he purchased a local paperback exchange, and with that Coas Books was born. The name Coas has its roots in archaeology, coming from the Nahuatl term ?coa? ? meaning digging stick ?, and the acronym for "Center of Anthropological Studies". Today, Coas Books is run and operated by Mike and Veronica Beckett as they continue to proudly serve the community in the heart of Las Cruces.

Visit Seller's Storefront

Seller's business information

Coas Books, Inc.
317 N. Main, Las Cruces, NM, 88001, U.S.A.

Sale & Shipping Terms

Terms of Sale

We accept most major credit cards and PayPal.

email: coas@coasbooks.com
phone: (575) 524-8471

Michael Beckett, President

Coas Books, Inc.
317 N. Main Street
Las Cruces, NM 88001

Please don't hesitate to contact us if you have any issues with your order!

Oders can be cancelled any time before the oder has been marked shipped. If you did not receive the item, or the item is not as described, you have 30 days from your actual or latest estimated delivery date to open a request for refund or replacem...

More Information

Shipping Terms

All orders are processed and shipped within 24 hours!
All US orders are shipped with Delivery Confirmation through USPS.

Economy Mail takes 7 to 14 Business Days to arrive.
Expedited Mail takes 2 to 5 Business Days to arrive.

International shipping varies by country and takes 14 to 30 Business Days to arrive.

Important Notice to International Buyers: Import duties, taxes, and other charges by your country's authorities are not included in the item price or shipping charges. Check with your local customs office to determine what these additional costs may be.