giovedì 31 dicembre 2015

Oracle refresh statistics and indexes

Some access plan are slower than expected? Some unexpected table scans performed even if the indexes are well defined?

General suggestion:

Refresh db statistics (go to -> database configuration -> refresh statistics)
Refresh indexes tables (go to -> database configuration -> refresh index tables)

Nessun commento:

Posta un commento