Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

So I have a script that runs daily. It creates a temp table then inserts the records to a table from the temp table. The script used to create indexes but few months ago I commented out the index creation. My question is, does the index still exist in the table? Will it still slow down the update, insert etc? I can see the index names in the index usage report.

share|improve this question
1  
What database are you using? – Justin Cave Feb 26 at 19:22
sql server 2008 – Liton Uddin Feb 26 at 19:57
Did it create indexes on the permanent table or temp table? – JNK♦ Feb 26 at 20:02
Why can't you open up the table in SSMS and just look? – Stu Feb 26 at 20:44
3  
"I can see the index names in the index usage report"... would suggest that the index still exists. – Mark Storey-Smith Feb 26 at 22:19
show 1 more comment

closed as not a real question by Mark Storey-Smith, Paul White, RolandoMySQLDBA, Aaron Bertrand, dezso Feb 27 at 7:35

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

Browse other questions tagged or ask your own question.