print Printer View e-mail E-mail this page Bookmark Bookmark
product logo Competitive Analysis: IBM DB2 UDB
Most significant differences between Oracle Database and IBM DB2 UDB, in the arena of performance and scalability.
 
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

For a more detailed comparison, see "Technical Comparison of Oracle Database vs. IBM DB2 UDB: Focus on Performance", an Oracle White Paper, May 2005

Back to Database Performance Page
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy