Function-Based Indexes And CURSOR_SHARING = FORCE

Video Tutorial: XPLAN_ASH Active Session History - Introduction

Unnecessary BUFFER SORT Operations - Parallel Concatenation Transformation

View Data Volume Estimates


New Version Of XPLAN_ASH Tool - Video Tutorial

"Cost-free" joins - 2

"Cost-free" joins - 1

HAVING Cardinality

New Version Of XPLAN_ASH Utility

Exchange Partition, Virtual Columns And Column Statistics

Parallel Execution Analysis Using ASH - The XPLAN_ASH Tool

Report Generators And Query Transformations

Column Groups - Edge Cases

Coalesce Subquery Transformation - COALESCE_SQ

Join Views, ROWIDs And Query Transformations

Dynamic Sampling And Indexes

Incremental Partition Statistics Review

Dynamic Sampling On Multiple Partitions - Bugs

Table Functions And Join Cardinality Estimates

Auto DOP And Direct-Path Inserts

Logical I/O Evolution - Part 3: 11g

Multi-Column Joins, Expressions and 11g

HCC And Virtual Columns

Flashback Query "AS OF" - Tablescan costs

Transitive Closure - Outer Joins

ASSM bug reprise - part 2

Things worth to mention and remember (II) - Parallel Execution Control 2

Parallel DML - Conventional (non-direct-path) Inserts As Select

Concurrent Index Creation