DBA_INDEX_USAGE
From: Charlotte Hammond <"Charlotte>
Date: Fri, 28 May 2021 17:06:17 +0000 (UTC)
Message-ID: <1887092961.1254468.1622221577124_at_mail.yahoo.com>
Date: Fri, 28 May 2021 17:06:17 +0000 (UTC)
Message-ID: <1887092961.1254468.1622221577124_at_mail.yahoo.com>
Hello all,
Please could somebody clarify for the me the distinction between these columns in DBA_INDEX_USAGE:
TOTAL_ACCESS_COUNT (Total number of times the index has been accessed)TOTAL_EXEC_COUNT (Total executions the index has participated in)
How can an index participate in an execution without being accessed? Why are these numbers not the same?
Thank you!
Charlotte
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 28 2021 - 19:06:17 CEST