Any script to find which index has never been used.?

[hrishy]

Hi

Yes you can put the index in a dedicated tablespace and use v$filestat to mointor it..it would give you a crude way of finding out wheather a index is used or not..

regards
Hrishy