Re: unused indexes (Informix 7.31)
Are you sure sysptntab (also in view sysptprof) collects the number of
access since last boot or onstat -z and not the one of current sessions?
> -----Ursprüngliche Nachricht-----
> Von: informix-list-bounces@iiug.org
> [mailto:informix-list-bounces@iiug.org]Im Auftrag von
> david@smooth1.co.uk
> Gesendet am: Dienstag, 27. Mai 2008 20:06
> An: informix-list@iiug.org
> Betreff: Re: unused indexes (Informix 7.31)
>
> 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.
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>