SQL_Surfer
SSCrazy Eights
Points: 8318
More actions
March 18, 2015 at 6:42 pm
#316332
I've a very large tables with 36625830 rows. It contans data for all the clients. I'm only interested to pull data for few clients and it still takes 30 + minute to pull that data using clientno as an index. Anything I can do to speed it up?
#1784958
Also made sure stats are up to date and index are not fragmented.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply