By querying these dynamic management views using a query similar to the one shown below you can see all of the indexes which the SQL Server recommends creating. Do NOT simply create these indexes.

An index stores both the values of a table's columns and a system of directions that enable access to rows in that table by index value. Defining an index on a column or set of columns enables SAS, ...

I wanted to get some suggestions for scheduled maintenace on a SQL Server 2000 box that is hosting a relatively small database ( ...