This is one of the important Oracle database 19c New feature. Automatic Indexing is one of the great feature included in 19c .
It automates index management tasks, such as creating, rebuilding, and dropping indexes in an Oracle Database based on changes in the application workload.