Clustered index-
Clustered index is used for easy retrieval of data from the database and is faster
Clustered index alters the way records are stored in a database as it sorts out rows by the column which is set to be clustered index.
One table can only have one clustered index.
Non Clustered index-
Non-Clustered index is used for easy retrieval of data from the database and is slower.
Non-Clustered index does not alter the way it was stored but it creates a separate object with a table which points back to the original table rows after searching…
One table can have many non-clustered indexes.
Answers (0)