pgd_Messages Clustered Indexhttp://www.aspplayground.net/forum/(c) ASP Playground Support Forum30 pgd_Messages Clustered Index (Guest) <br> Why is the clustered index on the pgd_Messages table on the lastupdate column? <br> <br> It means that if a message is updated, it's going to have to update a lot of index records.. <br> <br> If it's there to help viewing performance, surely it would have been on forumID, lastupdate rather than just lastupdate? <br> http://www.aspplayground.net/forum/fb.ashx?m=388571Fri, 01 Jul 2005 05:13:33 GMT