Partitioning

Which partitions does the SQL statement access?

Brief Introduction into Partitioning in #Oracle

Partition-Pruning: Do & Don’t

Recursive SQL

Interval Partitioning and Parallel Query Limit Access Paths

Truncate Partition

Materialized Views & Partition Change Tracking

Incremental Partition Statistics Review

Dynamic Sampling On Multiple Partitions - Bugs

Table rebuilds

So why do I need "so much extra space" for my partition SPLIT operation?

So why do I need "so much extra space" for my partition SPLIT operation?

Indexing

Partitioned Bitmaps

Status update on how MySQL handle the partition(s) for maintenance

CELL_PARTITION_LARGE_EXTENTS now obsolete

Prefixed

Upgrade issues

Exadata Part IV: Flash Cache

Local Indexes – 2

Local Indexes

Deferred Segment Creation as of 11.2.0.2

Cleanup of partitioned objects residing in offlined tablespaces

Partially Index a Table

Partition Wise Joins III – REF Partitioning

Partition Wise Joins III – REF Partitioning

Partition-Wise Join of List-Partitioned Tables

Data Warehousing Best Practices: Comparing Oracle to MySQL, part 2 (partitioning)

Using MySQL Partitioning Instead of MERGE Tables

The ODTUG aftermath… (hadoop, partitions and best practices)