cancel
Showing results for 
Search instead for 
Did you mean: 

Index is using or not

Sreenivasulu Raju.M
Occasional Contributor

Index is using or not

how to find the index is using or not
3 REPLIES
spex
Honored Contributor

Re: Index is using or not

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
Honored Contributor

Re: Index is using or not

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
Trusted Contributor

Re: Index is using or not

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