May 11, 2013 at 4:04 am
Dear,
Some of my tables contain more than 500 thousands rows. When I access those tables through my Application or execute a query, it takes time that is noticable.
So I think I need to do some maintenance/administrative tasks on those table. But I am stuck what to do.
Please suggest me what to do to improve the situation.
Rgds,
Akbar
May 11, 2013 at 4:47 am
You need to tune the queries, perhaps add indexes (and btw, 500000 rows is tiny)
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