SQL Server Indexes
Can somebody give me an example of the difference between clustered and non clustered indexes, and the benefits or uses of each?
Thanks in advance
Re: SQL Server Indexes
Clustered indexes define the physical sorting of a database tableís rows in the storage media. For this reason, each database table may have only one clustered index. If a PRIMARY KEY constraint is created for a database table and no clustered index currently exists for that table, SQL Server automatically creates a clustered index on the primary key.
Non-clustered indexes are created outside of the database table and contain a sorted list of references to the table itself. SQL Server 2000 supports a maximum of 249 non-clustered indexes per table. However, itís important to keep in mind that non-clustered indexes slow down the data modification and insertion process, so indexes should be kept to a minimum