Do nothing and improve Autonomous Database performance
summary
Autonomous Database runs a continuous automation engine that captures workload, creates hidden candidates, verifies them on a clone or via invisible indexes, then implements online changes; auto-indexing reduces index count while matching hand-tuned elapsed time by building smarter multi-column indexes; 3 materialized views improved 16 queries and cut a 77-query end-to-end run by about 23%; all changes are validated before becoming visible.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 1:30Database Structures
- 5:02Automation
- 9:49Cycle
- 14:46Invoke
- 16:39Configuration
- 19:23Reporting
- 20:41Reports
- 22:42Proof points
- 25:36Automatic materialized views
- 27:36Summary
related talks
24mAutomate Data Management with Autonomous Database
01mAutonomous Database
34mOracle Autonomous Database: simplify your database management
33mAutonomous Database: taking Oracle's most secure database to the next level
26mOptimize your workload with automatic indexing
30mWrite scalable SQL with Oracle Autonomous Database
33mEngineer More, Work Less: DBS’ Autonomous Database Journey
44mContinuous Database Administration