Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

A clustered index in sql server like a dictionary or telephone directory. A,B,C,D it goes on.
If you look up with a name Ozgur you start O then z etc.

I would like a simple explaination for this concept for oracle savy users.

More information about Clustered Indexes in Sql Server. What is a Clustered Index?

share|improve this question

1 Answer 1

up vote 7 down vote accepted

In Oracle terminology, it is an Index Organized Table, commonly referred to as an IOT.

An index-organized table has a storage organization that is a variant of a primary B-tree. Unlike an ordinary (heap-organized) table whose data is stored as an unordered collection (heap), data for an index-organized table is stored in a B-tree index structure in a primary key sorted manner. Each leaf block in the index structure stores both the key and nonkey columns.

share|improve this answer
1  
It is probably the closest thing to a clustered index, but it sure isn't the same thing. –  a_horse_with_no_name Nov 16 '11 at 9:49
    
@a_horse_with_no_name How do they differ? –  Mark Storey-Smith Nov 16 '11 at 9:53
2  
Hi horse! IN SQL Server the clustered index also is physically the table - the table data is physically stored in the index. –  Niall Litchfield Nov 16 '11 at 11:12
1  
@a_horse_with_no_name, after reading on IOTs, it's exactly the same thing as clustered indexes in SQL Server: a B-Tree with the index keys, and sorted leaves by the index keys. download.oracle.com/docs/cd/E14072_01/server.112/e10713/… –  Gonsalu Nov 16 '11 at 11:57
1  
@Gonsalu: but one of the differences is still that SQL Server can create a clustered index on non-unique (i.e PK) columns. Btw: I found this page quite interesting: use-the-index-luke.com/sql/clustering/… –  a_horse_with_no_name Nov 16 '11 at 13:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.