Hi all ....

Is there any tool or process (query) to help me know what indexes are not used in order to delete them?

Furthermore, I want to know what tables, views, columns are not used to do the same (delete), have you
any idea ?

I have a warehouse with hundreds of objects and a lot of space that I want to improve.


DB2 V7
z/OS v 1.4
90% of my SQL is DYNAMIC

Thanks for your help!

Ram



DB2 & UDB email list listserv db2-l LazyDBA home page