3 ms·
Clustered is directly related to the physical order of the records. Non-clustered is a logical order that uses pointers to the physical location. Only one clu
by binarymax 16y ago
Clustered is directly related to the physical order of the records. Non-clustered is a logical order that uses pointers to the physical location. Only one clustered is allowed per table.
http://en.wikipedia.org/wiki/Index_(database) http://en.wikipedia.org/wiki/Index_(database)
- ams6110 16y agoThe concept also does not exist in some databases. Oracle, IIRC, does not have the notion of a clustered index. SQL Server does. Another illustration of why you should not assume that all relational databases work the same way.
- binarymax 16y agoDB2 supports clustering, and Oracle has a similar concept: http://www.oracle-base.com/articles/8i/IndexOrganizedTables.php http://www.oracle-base.com/articles/8i/IndexOrganizedTables.... You are definitely right about each RDBMS having their own quirks though! Solid advice: know what you are working with and its nuances.