September 9, 2012 at 7:19 am
Hey guys, i really need some help here since i am a very new programmer, so i thank you in advance for your patience and advice. So, I have build a very large table; its nearly 4 billion record. however, I need to increase the performance. I would like to index it properly but am not sure how to go about doing this. there is a primary key on the table, and i would like to index it by time but let me know what y'all think.
Thanks so much!
CJ
September 9, 2012 at 8:09 am
Take a read through these:
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply