I had used dta for index suggestions and applied those suggestion.i run sp_helpindex[tablename] on one of my table and seems like dta had suggested indexes which are already there for those index keys(I have attached the screen shot). as you can see in the screenshot i have different indexes created for same index_keys. Is it every time I run DTA, it suggests index even though the index is already created for those keys? thanks for help
the_hareeb · Sep 30, 2010 11:31 AM · 1,397 views
This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.
Start a New Discussion