Take the 2-minute tour ×
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.

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

closed as not a real question by Mark Storey-Smith, Paul White, RolandoMySQLDBA, Aaron Bertrand, dezso Feb 27 '13 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, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
What database are you using? –  Justin Cave Feb 26 '13 at 19:22
    
sql server 2008 –  Liton Uddin Feb 26 '13 at 19:57
    
Did it create indexes on the permanent table or temp table? –  JNK Feb 26 '13 at 20:02
    
Why can't you open up the table in SSMS and just look? –  Stu Feb 26 '13 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 '13 at 22:19

Browse other questions tagged or ask your own question.