product logo Competitive Analysis: Microsoft SQL Server 2000
Most significant differences between Oracle Database and Microsoft SQL Server 2000, in the arena of performance and scalability.
 
Feature
Oracle Database
Microsoft SQL Server 2000
Concurrency Model

Multi-version read consistency

Non-Escalating row-level locking

Shared read locks or dirty reads

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

Not supported

Only local indexes with member tables

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

InfiniBand Network
Supported
Not supported

For a more detailed comparison, see " Technical Comparison of Oracle Database vs. SQL Server 2000: Focus on Performance", an Oracle White Paper, December 2003

Back to Database Performance Page


In-Memory Replay Banner