Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities
Language: English
Published by CreateSpace Independent Publishing Platform, 2014
- Softcover
- Used
Seller: Coas Books, Las Cruces, NM, U.S.A.Coas Books
AbeBooks seller since January 23, 1998
Condition: Used - Good
US$ 12.84
Quantity: 1 available
Add to basketItem description from seller
Paperback.
Seller Inventory # 55GQNY0000UE_ns
- Title
- Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities
- Author
- Meade, Kevin
- Publisher
- CreateSpace Independent Publishing Platform
- Publication year
- 2014
- Condition
- good
- Binding
- Soft cover
- Language
- English
- ISBN 10
- 1501022695
- ISBN 13
- 9781501022692
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
"Synopsis" may belong to another edition of this title.
Coas Books
Las Cruces, NM, U.S.A.
AbeBooks seller since January 23, 1998
Shipping rates within U.S.A.
| Item | 3 to 7 business days | 2 to 4 business days |
|---|---|---|
| First item | US$ 3.99 | US$ 10.99 |
Payment methods
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.…
Specialty
non-fiction, fiction, literature, children, young adult, textbooks, technicalSeller's business information
Coas Books, Inc.
317 N. Main
Las Cruces, NM U.S.A. 88001
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
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.