|
Feature
|
Oracle
Database
|
Microsoft
SQL Server 2005
|
|
Concurrency Model
|
Multi-version
read consistency
Non-Escalating
row-level locking
|
Not by default. Must be enabled
Locks escalate
|
|
Clustered configurations
|
Transparent scalability with Real Application
Clusters
|
Requires data partitioning in member tables
and Distributed Partitioned Views
|
|
Indexing capabilities
|
B-Tree indexes
Index-organized Tables
Bitmap indexes
Bitmap Join Indexes
|
B-Tree indexes
Clustered Indexes
Not supported
Not supported
|
|
Partitioning options
|
Range, hash, list and composite partitioning
Local and global indexes
|
Range and list
Local and global indexes
|
| Parallel execution |
Queries, INSERT, UPDATE, DELETE |
Queries only |
|
Additional data warehousing capabilities
|
Materialized Views
MERGE
Multi-table INSERT
Pipelined table Functions
|
Indexed Views
Not supported
Not supported
Not supported
|
Bookmark
