unused indexes (Informix 7.31)

Posted in 2008

revilofe — Tue, 27 May 2008 07:17:01 -0700 (PDT) — source: Usenet: comp.databases.informix

Hi everybody how do I know which index is used on a table when the program execute? I want to do a clean up of unused indexes and tables. Thanks. (informix 7.31)

↪ replying to revilofe

david@smooth1.co.uk — Tue, 27 May 2008 11:06:24 -0700 (PDT) — source: Usenet: comp.databases.informix

On 27 May, 15:17, revilofe <revil...@gmail.com> wrote: > Hi everybody > > how do I know which index is used on a table when the program execute? > I want to do a clean up of unused indexes and tables. > > Thanks. > > (informix 7.31) Unused since server boot? If the indexes are dettached try querying sysptntab in sysmaster.