Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Andy Warren Worst Practices - Not Using Primary Keys and Clustered Indexes RE: Worst Practices - Not Using Primary Keys and Clustered Indexes

  • August 1, 2002 at 6:29 am

    #433791

    If you're doing inserts where the value being indexed is not increasing then a clustered index is generally a BAD idea. You'll get lots of page splits. See Rob Vieira's book, "Professional SQL Server 2000 Programming" pp.283-4 and 294-7. I would like to have seen this discussed in the article. Otherwise it has good points.