I turned index monitoring on for about 100 indexes.

They all show that they are used.

I am kind of surprised that they all showed up as being used.

Is there anything that can cause these indexes to show as being used besides
user activity?

Thinks like updating stats for example.

TIA

Dustin




Oracle LazyDBA home page