Oracle 19c's Automatic Indexing: A Game-Changer for Database Management

Oracle has introduced a revolutionary feature in its latest version, Oracle 19c - Automatic Indexing. This innovative technology utilizes machine learning to optimize database performance by automatically creating, managing, and optimizing indexes based on workload patterns.

The system observes which SQL queries are run most frequently and how long they take to retrieve results. It then learns which queries require faster access to data and suggests or creates new indexes for the columns most often used in those queries. If certain indexes become less relevant over time, the system can remove or adjust them to maintain efficiency.

This intelligent indexing system is designed to adapt to evolving database patterns, minimizing administrative overhead and ensuring optimal performance.

Source: https://dev.to/mrcaption49/automatic-indexing-in-oracle-19c-version-6i2