Automatic caching for external tables

External Table Cache in Autonomous AI Database enables you to cache frequently accessed data from external tables in your database.

You can choose either policy-based or automatic caching for your external tables. With policy-based management, you define how caches are created, populated, refreshed, and retired, giving you precise control over cache contents and lifecycle. With automatic caching, the database manages the entire cache lifecycle, including creation, population, refresh, and drop of external table caches.

See Use External Table Cache to Improve Performance for External Tables for more information.