Index is using or not

[Sreenivasulu Raju.M]

how to find the index is using or not

[spex]

ALTER INDEX my_idx MONITORING USAGE;

SELECT * sys.v$object_usage
WHERE INDEX_NAME='my_idx'
ORDER BY used;

http://www.dbazine.com/oracle/or-articles/liu3

PCS

[spex]

ALTER INDEX my_idx MONITORING USAGE;

SELECT *
FROM sys.v$object_usage
WHERE INDEX_NAME='my_idx'
ORDER BY used;

http://www.dbazine.com/oracle/or-articles/liu3

PCS

[Piergiacomo Perini]

Hi Sreenivasulu Raju.M,

my 2 cent:

if you are talking about Oracle and if you are trying to check if index is used in a query then you have to use "explain plan".

In other case, you have to use STATISTICS.

hth
regards
pg