What are the options?
CREATE INDEX that identifies the indexes that may improve performance of your workload, creates the indexes, and verifies that they improve performance of the queries.
DROP INDEX that identifies redundant and duplicate indexes, and indexes that were not used in the long period of time.
PLAN REGRESSION CORRECTION that identifies SQL queries that are using execution plan that are slower than previous good plan, and uses the last known good plan instead of the regressed plan.
Very useful information.