Prev Thread Prev Thread   Next Thread Next Thread
 pgd_Messages Clustered Index
Author Message
Guest
pgd_Messages Clustered Index - 07/01/2005 05:13:33 AM

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?

  Enter the code shown; Click to reload image.
Post Message Preview
Jump to:

Current active users
There are 0 members and 1 guests.
Icon Legend and Permission
  • New Messages
  • No New Messages
  • Hot Topic w/ New Messages
  • Hot Topic w/o New Messages
  • Locked w/ New Messages
  • Locked w/o New Messages
  • Read Message
  • Post New Thread
  • Reply to message
  • Post New Poll
  • Submit Vote
  • Post reward post
  • Delete my own posts
  • Delete my own threads
  • Rate post

© 2000-2008 ASPPlayground.NET Forum Version 3.2 a