Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities
暫譯: Oracle SQL 性能調優與優化：一切都關於基數

Kevin Meade

Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities
  • 出版商: CreateSpace Independ
  • 出版日期: 2014-09-16
  • 售價: $1,670
  • 貴賓價: 9.5 折 $1,587
  • 語言: 英文
  • 頁數: 568
  • 裝訂: Paperback
  • ISBN: 1501022695
  • ISBN-13: 9781501022692
  • 相關分類: Oracle、SQL

    • 海外代購書籍(需單獨結帳)

相關主題

商品描述

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 Analysis 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

商品描述(中文翻譯)

本書由一位擁有三十年 Oracle RDBMS 經驗的資深資料庫管理員撰寫，旨在教授 Oracle 資料庫的 SQL 調優技巧。這不是一份一次性技巧或提示的清單，也不是對主題的簡單概述；本書提供了一個深入的過程，涵蓋發現、分析和問題解決。了解 SQL 調優背後的科學。

- 學習並應用基於過濾行百分比的基數調優方法
- 確定查詢的驅動表和連接順序
- 構建查詢圖、數據模型和連接樹
- 建立並使用計數/過濾/重建查詢
- 識別查詢執行計劃中的浪費
- 使用預估值與實際值聚焦於基數偏差
- 使用 ACCESS / FILTER / COVERAGE 策略為問題查詢建立索引
- 利用 2% 規則分析訪問方法和連接方法
- 將查詢分類為精確風格或倉庫風格
- 理解 Hash Join 的機制並加快 Hash Join 的速度
- 使 HINTS 作為檢測工具而非武器
- 避免早期資料庫設計缺陷
- 管理統計數據並處理常見的統計問題
- (NDV、均勻分佈、獨立性、動態取樣)
- (陳舊性、偏斜、依賴性、默認、越界、瞬態、膨脹)
- 完善你的問題導向分析技術
- 以及更多內容

本書還包括：針對 EXADATA 的特別章節、一個展示基數調優過程的實驗室，以及二十三個神奇的 SQL 腳本，使 SQL 調優過程變得簡單易行。學習由專業人士教授的 SQL 調優技巧，成為你公司中的專家。

- 第 1 章：驅動表和連接順序
- 第 2 章：使用查詢執行計劃的方法
- 第 3 章：查詢的最佳索引
- 第 4 章：連接
- 第 5 章：提示
- 第 6 章：基礎知識
- 第 7 章：行計數和執行時間
- 第 8 章：EXADATA
- 實驗室：反向工程查詢執行計劃
- 附錄：了解你的腳本
- 用於分析查詢和計劃的腳本
- 用於檢查活動資料庫的腳本
- 用於查看元數據的腳本

- showplan
- showplanshort
- showplanconstraints
- showplancountqueries
- showplandatamodel
- showplandrivingtable
- showplanfilterqueries
- showplanfrpspreadsheetcode
- showplanindexes
- showplannumrows
- showplanquerydiagram
- showplantables
- showplantablesunique
- loadplanfromcache
- loadplanfromhist
- showtopcpu
- showowner
- showindexes
- showconstraints
- showcolstats
- showhistograms
- showallscanrates
- showallworkareas

一切都與基數有關。

類似商品

最後瀏覽商品 (20)