• tamie.mcdonald (3/11/2010)


    Why would you cluster an index for an Identity column key?

    ...so wouldn't you want to cluster it around a logical key?

    I too have the same curiosity. It's purely academic, mainly because I'm only now getting into the fine-tuning of an existing database and while I could research other articles, these are exactly the questions I have. Hopefully a good discussion will stem from this (or some links to some of those articles I need to read... 😉 )