Обсуждение: idx_scan =0, but idx_blks_read > 0

Поиск
Список
Период
Сортировка

idx_scan =0, but idx_blks_read > 0

От
Marc Mamin
Дата:
Hello,
 
(9.4)
 
I'm not quite sure how to interpret these figures.
Does it means that index blocks get read for maintenance purpose, e.g. after a row update, but the index itself is never used?
 
Thanks,
 
Marc Mamin