You create an Oracle 12c database and then import schemas that are required by an application which has not yet been developed. You want to get advice on creation of or modifications to indexes…

While SQL Access Advisor can use a SQL Tuning Set, a SQL Tuning Set is derived from an existing workload, which is not available for an application that has not yet been developed.

The Automatic Database Diagnostic Monitor (ADDM) analyzes existing workloads and performance data to identify bottlenecks, making it unsuitable for proactive design advice on an undeveloped application.

The SQL Tuning Advisor focuses on tuning individual or a set of SQL statements, providing recommendations for *existing* SQL, not comprehensive schema-level design advice for an undeveloped application.

The SQL Access Advisor is the specific Oracle tool designed to recommend schema object changes, including indexes, materialized views, and partitioning strategies, to improve query performance. Since the application is not yet developed, a hypothetical workload is required to provide the advisor with expected SQL statements for analysis.

The SQL Performance Analyzer is used to assess the impact of database changes on SQL performance by comparing SQL workloads before and after a change, not for initial design advice on schema objects for a new application.