Thread: idx_scan =0, but idx_blks_read > 0

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