Loading Events

« All Events

One Less Thing For DBAs to Worry About: Automatic Indexing

6 May @ 12:00 pm - 1:00 pm AEST

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.

Presenter : Jim Czuprynski

You must register at https://attendee.gotowebinar.com/register/7382876839054138637  if you want to attend this event.

 

Details

Date:
6 May
Time:
12:00 pm - 1:00 pm
Event Category:

Organiser

Conference Manager
Phone:
0411 231 198
Email:
conferencemanager@ausoug.org.au