Oracle 19c brings us a very powerful new feature for index management called ‘Automatic Indexing’. This feature can detect the need for indexes, create, test, and drop them automatically – without DBA intervention. This presentation will discuss all the components of automatic indexing and what they do. The attendee will further learn how to enable/disable automatic indexing, control it at the schema-level, and see several examples of automatic indexes in action. Finally, I’ll show how this feature can be used during the development lifecycle through the maturity of a database application – even without having an Oracle engineered system.