The SQL Access Advisor works similarly to the SQL Tuning Advisor, and the analysis will focus on testing the impact of adding a new index and also, upon request, the Materialized Views as well as removing unused indexes and Materialized Views.

The recommendations include scripts that you can use to create the recommended indexes and Materialized Views.