Description

Oracle SQL Performance Tuning and Optimization by Kevin Meade Estimated delivery 3-12 business days Format Paperback Condition Brand New 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 tuningDetermine a query's Driving Table and Join OrderConstruct Query Diagrams, Data Models, and Join TreesBuild and use Count / Filter / and Reconstruction QueriesIdentify Waste in a Query Execution PlanZero in on Cardinality Divergence using Estimated vs. ActualsUse the ACCESS / FILTER / COVERAGE strategy to build indexes for Problem QueriesExploit THE 2% RULE in analyzing Access method and Join methodClassify queries as Precision Style or Warehouse StyleUnderstand Hash Join mechanics and make Hash Joins go fasterMake HINTS work as Detection Tools rather than clubsAvoid early Database Design flawsManage 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 Techniqueand 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 ORDERChapter 2: Ways to Use a Query Execution PlanChapter 3: The Best Indexes for a QueryChapter 4: JOINSChapter 5: HINTSChapter 6: BASICSChapter 7: ROW COUNTS and RUN TIMESChapter 8: EXADATALAB: Reverse Engineering the QEPAppendix: Know Your ScriptsScripts for analyzing queries and plansScripts for examining an active databaseScripts for looking at metadata showplanshowplanshortshowplanconstraintsshowplancountqueriesshowplandatamodelshowplandrivingtableshowplanfilterqueriesshowplanfrpspreadsheetcodeshowplanindexesshowplannumrowsshowplanquerydiagramshowplantablesshowplantablesuniqueloadplanfromcacheloadplanfromhistshowtopcpushowownershowindexesshowconstraintsshowcolstatsshowhistogramsshowallscanratesshowallworkareas It's all about the Cardinalities Details ISBN 1501022695 ISBN-13 9781501022692 Title Oracle SQL Performance Tuning and Optimization Author Kevin Meade Format Paperback Year 2014 Pages 570 Publisher Createspace Independent Publishing Platform GE_Item_ID:92691694; About Us Grand Eagle Retail is the ideal place for all your shopping needs! With fast shipping, low prices, friendly service and over 1,000,000 in stock items - you're bound to find what you want, at a price you'll love! Shipping & Delivery Times Shipping is FREE to any address in USA. Please view eBay estimated delivery times at the top of the listing. Deliveries are made by either USPS or Courier. We are unable to deliver faster than stated. International deliveries will take 1-6 weeks. NOTE: We are unable to offer combined shipping for multiple items purchased. This is because our items are shipped from different locations. Returns If you wish to return an item, please consult our Returns Policy as below: Please contact Customer Services and request "Return Authorisation" before you send your item back to us. Unauthorised returns will not be accepted. Returns must be postmarked within 4 business days of authorisation and must be in resellable condition. Returns are shipped at the customer's risk. We cannot take responsibility for items which are lost or damaged in transit. For purchases where a shipping charge was paid, there will be no refund of the original shipping charge. Additional Questions If you have any questions please feel free to Contact Us. Categories Baby Books Electronics Fashion Games Health & Beauty Home, Garden & Pets Movies Music Sports & Outdoors Toys