April 9, 2009 at 12:46 am
in sql 2000 a table has large number of rows
while creating the index on a field to system goes unresponsive for a long time
so I canceled the operation
After that the response time of the server has increased. get worse
I created the same index again but the response. time has not improved.
how I can resolve this issue.
April 9, 2009 at 12:12 pm
update stats for the DB and check if it helps
April 9, 2009 at 12:40 pm
It's really hard to say based on the information provided. Are you sure that the slow response on the system is due to this table in particular? If so, do you have an actual execution plan for the queries run against that table? Those will tell you whether or not the index you added is one that is needed.
Do you have statistics maintenance routines running? Do you defragment your indexes when needed? Does the table have a clustered index?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply