No clustered index hell

Last Post 09 Jan 2009 06:58 AM by timcronin. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
timcronin
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
You are not authorized to post a reply.

Acceptable Use Policy