Oracle 19c Automatic Indexing

Question

It seems Oracle automatic indexing feature that was introduced in Oracle 19c works only on Oracle Cloud and not AWS RDS.

Is my understanding correct (that AWS RDS doesn't support it)?

Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-89C2-4916A0E7AC87

Answer 1

Yes your understanding is correct. Automatic Indexing is not supported on Amazon RDS. Automatic Indexing works only on Oracle Database Enterprise Edition (19c+) when the database is hosted on an Oracle Engineered System (an Exadata machine). Such a system can be an Oracle Exadata machine on premises or sitting in the Oracle Pubic Cloud (using the Exadata Cloud Service or the Autonomous Database Service)