Indexes are used in databases and they are used to create tables. Each is used to create independent data. This approach is basically used in SQL Server 2000 database.
The major differences between the cluster and non cluster indexes are as follows.
Cluster Index
1 A cluster index is a form of tables which consist of column and rows.
2 Cluster index exists on the physical level
3 It sorts the data at physical level
4 It works for the complete table
5 There is a whole table in form of sorted data
6 A table can contain only one cluster index
Non Cluster Index
1 A non cluster index is in the form of a report about the tables.
2 They are not created on the physical level but at the logical level
3 It does not sort the data at physical level
4 A table has 255 non clustered indexes
5 A table has many non clustered indexes.
6 It work on the order of data
The table can have indexes in many forms. A table cannot have a single index in it, neither cluster and nor non cluster index. It is also possible that a table has only single cluster index and does not have any non clustered index or vice versa.
The major differences between the cluster and non cluster indexes are as follows.
Cluster Index
1 A cluster index is a form of tables which consist of column and rows.
2 Cluster index exists on the physical level
3 It sorts the data at physical level
4 It works for the complete table
5 There is a whole table in form of sorted data
6 A table can contain only one cluster index
Non Cluster Index
1 A non cluster index is in the form of a report about the tables.
2 They are not created on the physical level but at the logical level
3 It does not sort the data at physical level
4 A table has 255 non clustered indexes
5 A table has many non clustered indexes.
6 It work on the order of data
The table can have indexes in many forms. A table cannot have a single index in it, neither cluster and nor non cluster index. It is also possible that a table has only single cluster index and does not have any non clustered index or vice versa.