Posts

Showing posts with the label 11g

Function based indexes and or expansion.

Ash data summary by partition

Inject hints using manual SQL profiles

Utl_raw.cast_to_date & column low/high values

Basic index compression - identify candidates and estimate prefix length

Filter by date range based on PK id.