Automatic SQL Tuning

SQL Plan Management Evolve Advisor

Optimizer Statistics Advisor

Automatic Optimizer Statistics Collection

Automatic Segment Advisor

Create an index on SALES.TIME_ID to force the return of rows in the order specified by the ORDER BY clause.

Replace the FETCH FIRST clause with ROWNUM to enable the use of an index on SALES.

Collect a new set of statistics on PRODUCT, CUSTOMERS, and SALES because the current stats are inaccurate.

Enable Adaptive Plans so that Oracle can change the join method as well as the join order for this query.

Create an index on SALES.CUST_ID to force an INDEX RANGE SCAN on this index followed by a NESTED LOOP join between CUSTOMERS and SALES.

It always gives preference to the IM column store clause defined at the tablespace level over table-level definitions.

It must always transport existing INMEMORY attributes.

Its INMEMORY_CLAUSE of the Data Pump Export allows modifications to IM column store clause of a table with existing INMEMORY setting

Its TRANSFORM clause can be used to add the INMEMORY clause to exported tables that lack them.

It ignores the IM column store clause of the exporting objects.

It can generate the INMEMORY clause that matches the table settings at export time.

storage, network, and interconnect changes

operating system upgrades

changes to database initialization parameters

database consolidation for pluggable databases (PDBs)

operating system and hardware migrations

recommendations regarding the creation of additional indexes

recommendations regarding rewriting the SQL statements

recommendations regarding the creation of materialized views

recommendations regarding the creation of SQL Patches

recommendations regarding partitioning the tables