|
Feature
|
Oracle Database
|
IBM DB2 UDB
|
|
Concurrency Model
|
Multi-version read consistency
Non-Escalating row-level locking
|
No
Locks escalate
|
|
Clustered configurations
|
Transparent scalability with Real Application Clusters
|
Rigid data partitioning required with DB2 EEE
|
|
Indexing capabilities
|
Wide variety of indexing schemes
|
Only B-Tree and dynamic bitmap indexes
|
|
Partitioning options
|
Range, hash, list and composite partitioning
Local and global indexes
|
Only hash partitioning
Only local indexes
|
|
Additional data warehousing capabilities
|
Multi-table INSERT
|
Not supported
|
|
Intelligent advisories
|
Access, SQL Tuning, Index, Summary, Memory, MTTR
|
Index advisory only
|
|
Self-tuning capabilities
|
Automatic Performance Diagnosis
Automatic SQL Tuning
Self-tuning memory, free space, and I/O management
|
No equivalent or limited capabilities
|
Database
Printer View