No clustered index hell

Last Post 09 Jan 2009 06:58 AM by timcronin. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

09 Jan 2009 06:58 AM
I have to support a large (100 gig+) database with about 230 users. It is 3rd party. They have almost no clustered indexes on any of their 1100 tables. They do have unique indexes on all the tables which all have a guid as this index. I realize with any good db design each table should have a clustered index, but with them using the guid as the unique index aren't I asking for trouble making that a clustered index considering the nature of the guid data

Acceptable Use Policy