Oracle Database 19c SIG Meeting

One Less Thing For DBAs to Worry About: Automatic Indexing

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 Indexing (AI) – 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.

Presented by Jim Czuprynski, Zero Defect Computing

Jim Czuprynski has nearly four decades of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies before becoming an Oracle DBA in 2001. He has been an Oracle ACE Director in 2014 and is a sought-after public speaker on Oracle Database technology features, presenting often at Oracle OpenWorld, COLLABORATE, ODTUG Kaleidoscope, Oracle CODE events, Oracle Development Community tours, and Oracle User Group conferences around the world. 

Jim has authored 100+ articles on Oracle Database administration, ML/analytics, and APEX since 2003 at databasejournal.com, IOUG SELECT, and ODTUG TechCeleration and has co-authored four books on Oracle database technology. Jim’s blog, Generally … It Depends (https://jimczuprynski.wordpress.com), contains his regular observations on all things Oracle and the state of the IT industry.