0 votes
in Sql by

What is the difference between clustered and non-clustered indexes?

1 Answer

0 votes
by

The differences between the two are as follows:

One table can have only one clustered index but multiple non-clustered indexes.

Clustered indexes can be read rapidly rather than non-clustered indexes.

Clustered indexes store data physically in the table or view whereas, non-clustered indexes do not store data in the table as it has separate structure from the data row.

Related questions

0 votes
asked Nov 7, 2021 in Sql by rajeshsharma
0 votes
asked Mar 18, 2023 in Oracle by GeorgeBell
...