Operating System - HP-UX
1748002 Members
4427 Online
108757 Solutions
New Discussion юеВ

Re: 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 3
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