Obtain additional assistance

There are automated tools available to help you find missing indexes that ought to be added, as well as identifying unused indexes that can be dropped. A web search on "SQL Server index optimization" will result in numerous links to such tools.

You can also consult web resources for SQL Server database maintenance for specific information about those databases. For more information, see the Microsoft SQL Server web site.