SQL server DTA question

Archived from the original Sajha.com — preserved as posted, replies can no longer be added here.
Start a New Discussion
Archived Post

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

Replies
No replies yet.

This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.

Start a New Discussion

You might be interested in...

Recent Classifieds View all
Upcoming Events View all
Service Providers View all