Thursday, February 26, 2009

What types of indexes are available in Microsoft SQL Server?

Microsoft SQL Server two types of indexes as follows:

1. Clustered Index: This defines physical sorting of the database table rows in the storage.
2. Non-clustered Index: This defines outside the database table. This contains sorted list of database references/pointers.

Note: There are limitations on number of indexes one can define on database table.

No comments: