{"product_id":"oracle-sql-performance-tuning-and-optimization-its-all-about-the-cardinalities-paperback","title":"Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eKevin Meade\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eWritten 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.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eLearn and apply the FILTERED ROWS PERCENTAGE Cardinality based method of tuning\u003c\/li\u003e \u003cli\u003eDetermine a query's Driving Table and Join Order\u003c\/li\u003e \u003cli\u003eConstruct Query Diagrams, Data Models, and Join Trees\u003c\/li\u003e \u003cli\u003eBuild and use Count \/ Filter \/ and Reconstruction Queries\u003c\/li\u003e \u003cli\u003eIdentify Waste in a Query Execution Plan\u003c\/li\u003e \u003cli\u003eZero in on Cardinality Divergence using Estimated vs. Actuals\u003c\/li\u003e \u003cli\u003eUse the ACCESS \/ FILTER \/ COVERAGE strategy to build indexes for Problem Queries\u003c\/li\u003e \u003cli\u003eExploit THE 2% RULE in analyzing Access method and Join method\u003c\/li\u003e \u003cli\u003eClassify queries as Precision Style or Warehouse Style\u003c\/li\u003e \u003cli\u003eUnderstand Hash Join mechanics and make Hash Joins go faster\u003c\/li\u003e \u003cli\u003eMake HINTS work as Detection Tools rather than clubs\u003c\/li\u003e \u003cli\u003eAvoid early Database Design flaws\u003c\/li\u003e \u003cli\u003eManage Statistics and deal with common Statistics problems\u003c\/li\u003e \u003cul\u003e \u003cli\u003e(NDV, Uniform Distribution, Independence, Dynamic Sampling)\u003c\/li\u003e \u003cli\u003e(Staleness, Skew, Dependence, Defaulting, Out-Of-Bounds, Transiency, Bloat)\u003c\/li\u003e \u003c\/ul\u003e \u003cli\u003ePerfect your Question Based Analyis Technique\u003c\/li\u003e \u003cli\u003eand more\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eIncluded 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.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eChapter 1: DRIVING TABLE and JOIN ORDER\u003c\/li\u003e \u003cli\u003eChapter 2: Ways to Use a Query Execution Plan\u003c\/li\u003e \u003cli\u003eChapter 3: The Best Indexes for a Query\u003c\/li\u003e \u003cli\u003eChapter 4: JOINS\u003c\/li\u003e \u003cli\u003eChapter 5: HINTS\u003c\/li\u003e \u003cli\u003eChapter 6: BASICS\u003c\/li\u003e \u003cli\u003eChapter 7: ROW COUNTS and RUN TIMES\u003c\/li\u003e \u003cli\u003eChapter 8: EXADATA\u003c\/li\u003e \u003cli\u003eLAB: Reverse Engineering the QEP\u003c\/li\u003e \u003cli\u003eAppendix: Know Your Scripts\u003c\/li\u003e \u003cul\u003e \u003cli\u003eScripts for analyzing queries and plans\u003c\/li\u003e \u003cli\u003eScripts for examining an active database\u003c\/li\u003e \u003cli\u003eScripts for looking at metadata\u003c\/li\u003e \u003c\/ul\u003e \u003cul\u003e \u003cli\u003eshowplan\u003c\/li\u003e \u003cli\u003eshowplanshort\u003c\/li\u003e \u003cli\u003eshowplanconstraints\u003c\/li\u003e \u003cli\u003eshowplancountqueries\u003c\/li\u003e \u003cli\u003eshowplandatamodel\u003c\/li\u003e \u003cli\u003eshowplandrivingtable\u003c\/li\u003e \u003cli\u003eshowplanfilterqueries\u003c\/li\u003e \u003cli\u003eshowplanfrpspreadsheetcode\u003c\/li\u003e \u003cli\u003eshowplanindexes\u003c\/li\u003e \u003cli\u003eshowplannumrows\u003c\/li\u003e \u003cli\u003eshowplanquerydiagram\u003c\/li\u003e \u003cli\u003eshowplantables\u003c\/li\u003e \u003cli\u003eshowplantablesunique\u003c\/li\u003e \u003cli\u003eloadplanfromcache\u003c\/li\u003e \u003cli\u003eloadplanfromhist\u003c\/li\u003e \u003cli\u003eshowtopcpu\u003c\/li\u003e \u003cli\u003eshowowner\u003c\/li\u003e \u003cli\u003eshowindexes\u003c\/li\u003e \u003cli\u003eshowconstraints\u003c\/li\u003e \u003cli\u003eshowcolstats\u003c\/li\u003e \u003cli\u003eshowhistograms\u003c\/li\u003e \u003cli\u003eshowallscanrates\u003c\/li\u003e \u003cli\u003eshowallworkareas\u003c\/li\u003e \u003c\/ul\u003e \u003c\/ul\u003e \u003cp\u003eIt's all about the Cardinalities\u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 570\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 1.16 x 9.25 x 7.52 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e September 16, 2014\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":47212611633401,"sku":"9781501022692","price":52.63,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0789\/2782\/3097\/files\/R29ueUcydnlQbk9GcElBWUVhM1poQT09.webp?v=1768094691","url":"https:\/\/bookscloud.io\/products\/oracle-sql-performance-tuning-and-optimization-its-all-about-the-cardinalities-paperback","provider":"BooksCloud Book Dropshipping","version":"1.0","type":"link"}