Oracle Database のパフォーマンスに関する落書き

Data Structures

  • Heap-Organized Tables
  • B-Tree Indexes and IOTs
  • Bitmap Indexes
  • Table Clusters

Algorithm

Query Transformations
  • OR Expansion
  • View Merging
  • Predicate Pushing
  • Subquery Unnesting
  • Query Rewrite with Materialized Views
  • Star Transformation
  • In-Memory Aggregation
  • Table Expansion
  • Join Factorization
Access Paths
  • Table
    • Full Table Scans
    • Table Access by Rowid
    • Sample Table Scans
  • Index
    • Index Unique Scans
    • Index Range Scans
    • Index Full Scans
    • Index Fast Full Scans
    • Index Skip Scans
    • Index Join Scans
  • Bitmap Index
    • Bitmap Index Single Value
    • Bitmap Index Range Scans
    • Bitmap Merge
    • Bitmap Index Range Scans
  • Cluster
    • Cluster Scans
    • Hash Scans
Join
  • Join Methods
    • Nested Loops Joins
    • Hash Joins
    • Sort Merge Joins
    • Cartesian Joins
  • Join Types
    • Inner Joins
    • Outer Joins
    • Semijoins
    • Antijoins
  • Join Optimizations
    • Bloom Filters
    • Partition-Wise Joins

Statistics Types

  • Table Statistics
  • Column Statistics
  • Index Statistics
  • Session-Specific Statistics for Global Temporary Tables
  • System Statistics
  • User-Defined Optimizer Statistics

参考


追記(2015/04/14):

  • 実行計画の見方
  • ヒント句の使い方
  • SQLレスポンス劣化原因調査方法
    • SQLT, SQLHC
    • EM、DBA_HIST_*、ASH、V$