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.
Thursday, February 26, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment