Last access time for index

[sandeep.iitk@gmail.com]

Hi DBA's,
Greetings!!!
I wanted to know the frequency of indexes used, by which
way i want to identify which indexes are of no use. Need help , please
show me the direction.
Is there any column in any catalog table which tells me about last
access time of a column.

My db2 specifications are
DB2 v8.1.1.112, fixpak 12 on AIX 5.3 non partitioned.

Thanks
Sandy

[Ram]

Re: Last access time for index

On Nov 10, 9:53 am, "sandeep.i...@g mail.com" <sandeep.i...@g mail.com>
wrote:

Hi DBA's,
 Greetings!!!
              I wanted to know the frequency of indexes used, by which
way i want to identify which indexes are of no use. Need help , please
show me the direction.
Is there any column in any catalog table which tells me about last
access time of a column.
>
My db2 specifications are
DB2 v8.1.1.112, fixpak 12 on AIX 5.3 non partitioned.
>
Thanks
Sandy

Sandy, you can try using the DB2 Design Advisor to do this. Given
your application workload, DB2 Design Advisor can recommend which
indexes to keep and which ones to drop. See below for details:

http://www.ibm.com/developerworks/db2/library/techarticle/dm-0508mcinerney/

Best regards,
-ram