That is a might big topic. I would not rely too heavily on DTA or the missing indexes views. In fact, I would probably not even look at them. The absolute best approach to figuring out what indexes you need on your system can't be handled on an online forum. You have to have access to so many things to dial this thing in. This type of thing also needs to be considered as a process instead of event. You can't just "add all the proper indexes" and then move on. It is an ongoing balance.
You should probably read up on indexes. The stairways series on here is excellent. It starts out basic and gets pretty deep.
http://www.sqlservercentral.com/stairway/72399/[/url]
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/