Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Clustered Index

Author  Topic 

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2001-02-27 : 09:41:58
When creating a Primary Key that is an identity number it is also automatically created as a clustered index.

Is this a good idea to keep it as such ? I was always under the impression that an identity number was a bad candidate for a clustered index.

Can anyone enlighten me please

   

- Advertisement -