SQL Server will gladly tell you about missing indexes, but it may not give you the keys in the right order.