patternsqlMinor
What is Sql Server Clustered Index in Oracle terminology
Viewed 0 times
clusteredwhatterminologysqlserverindexoracle
Problem
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?
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?
Solution
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.
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.
Context
StackExchange Database Administrators Q#7951, answer score: 7
Revisions (0)
No revisions yet.