Analyzing Database Indexes-SYM-400

Analyzing Database Indexes-Analyzing Database Indexes-What is the best way to analyze database indexes so that they run in an optimal fashion? Provide examples to support your analysis.