DB019 One Less Thing To Worry About: Automatic Index Creation (AIC) 

Automatic Index Creation (AIC) – a new feature in Oracle 19c – is an intriguing alternative to reactive performance tuning methodologies for index creation. We’ll show AIC reacts to heavy application workloads while it implements only the most appropriate indexes for improved database performance.

You’re a busy Oracle DBA. Your phone rings. It’s your most troublesome user, once again complaining that her query is running slow. You take a quick look at the execution plan, find a possible choice for a new index to improve its performance, and drop it in place: Problem solved. Or is it? Even an experienced DBA may not immediately realize the impact that new index will have on the performance of dozens of other queries and DML statements.

Finally, there’s a better way: Let the database decide.

This session will show how Automatic Index Creation (AIC) – one of the newest features of Oracle Database 19c – provides an intriguing alternative to reactive performance tuning methodologies for index creation. We’ll look at how AIC reacts to a heavy hybrid application workload and then holistically builds, tests, and implements the most appropriate secondary indexes needed to improve database performance.

Through presentations and online demonstrations, this session explains: – How AIC chooses which secondary indexes are most beneficial – What happens to secondary indexes deemed not beneficial right now … or never – How AIC reveals the results of its intelligent index creation