DB2 Tips n Tricks Part 25 – How to Find unused tables,indexes or stored procedures in the Database
How to Find unused tables,indexes or stored procedures in the Database.
When it was last accessed?
Solution:
LASTUSED Column in SYSCAT.TABLES,SYSCAT.INDEXES,SYSCAT.PACKAGES
Happy Learning & Sharing
Comments are closed.