How does auto indexing specifically improve query performance in an Autonomous Database environment?

Auto indexing improves query performance by analyzing SQL queries and identifying data access patterns that would benefit from faster lookups. It creates highly selective B-tree indexes on columns frequently used in WHERE clauses, JOIN conditions, or ORDER BY clauses. By doing so, it significantly reduces the amount of data the database needs to scan, leading to faster query execution times, reduced I/O, and more efficient resource utilization, all without requiring manual tuning.