Auto-Indexing Deep Dive

preview_player
Показать описание
Auto-Indexing can help developers save a lot of time by automating performance tuning for their application schemas, especially as the features changes over time and the system scales to larger data sizes. Auto-Indexing has controls that allow it to be used in different ways and in different scopes, so this session will review the scope of capabilities and best practices and how to monitor the dynamic changes made over time.

Рекомендации по теме
Комментарии
Автор

Is it only at 45 minutes that you mention it’s an exadata only feature?

rydmerlin
Автор

It seems to be optimized to detect Plan regressions and not-eff3ctive index candidates, but how does it deal with the additional io caused already by the invisible index? Can the additional cost on insert/Update be weighted?

berndeckenfels