Difference between Oracle and SQL Server Indexes
| Type of index |
SQL
Server 2008 R2
|
Oracle
11g
|
Yes (Non-clustered)
|
Yes (Default)
|
|
| B+ tree indexes |
Yes
(CI)
|
Yes
(IOT)
|
| Function Based Indexes |
Yes
(Column has to exist in table)
|
Yes
|
| Hash cluster indexes |
No
|
Yes
|
| B-Tree cluster indexes |
No
|
Yes
|
| Bitmap Indexes |
No
|
Yes
|
Here,
CI
- Clustered
Indexes
IOT
- Index Organized Tables
Note:
Both
SQL
Server 2008 R2 and Oracle 11g supports Filtered
Indexes
No comments:
Post a Comment