Register | Login

How to find the last used date of an index

Posted by jyothsnav 2216 days ago (Editorial)

In earlier versions of DB2, we donot have the facility to find the last used date of an index. But in V9.7, this feature is available which will help us in analysing the real usage of that index and whether it is required.


Command:


SELECT LASTUSED FROM SYSCAT.INDEXES WHERE INDNAME='?'


OR


SELECT INDNAME,LASTUSED FROM SYSCAT.INDEXES WHERE TABNAME='?'


 



Who Voted for this Article



YourWiz.com, is a website that will allow everyone to share their knowledge, tip or information through community micro blogging.