Guest
-
Total Posts
:
888
-
Reward points
:
0
- Joined: May 23 '01
-
Status: online
|
pgd_Messages Clustered Index
Fri. Jul 1, '05 5:13 AM
( permalink)
Why is the clustered index on the pgd_Messages table on the lastupdate column? It means that if a message is updated, it's going to have to update a lot of index records.. If it's there to help viewing performance, surely it would have been on forumID, lastupdate rather than just lastupdate?
|
|
|
|