How are optimizer statistics managed in ATP?

In Autonomous Transaction Processing (ATP), optimizer statistics are automatically managed as part of the database maintenance activities. This means that the system regularly collects and updates statistics for all tables without requiring manual intervention from users. This automatic process ensures that the database optimizer has accurate and up-to-date information to make informed decisions about query execution plans, ultimately leading to improved performance.

The automatic management of optimizer statistics is designed to optimize system resources and enhance efficiency, as it eliminates the need for database administrators to manually gather statistics. This feature aligns with the autonomous nature of the database, allowing it to adapt and adjust dynamically.

This approach also helps maintain the database’s overall health and performance, as it ensures statistics are continuously refreshed, accounting for changes in data distribution and volume. In contrast, other options suggest methods that either necessitate user involvement or apply only in specific circumstances, which are not reflective of the inherent capabilities of ATP's automatic maintenance.