Index statistics

Posted in 1999

↪ replying to Monika Rabold S.u.S.E. Linux 5.3

Arun Shastry — Tue, 06 Apr 1999 11:19:22 -0400 — source: Informix-list mailing list archive (1991-1998)

Index usage won't show up in any system tables, however data in your system tables do influence the index usage (update stats). If you look at the query plan by turning explain on, you'll see if an index is being used or not. Also, another way of influencing an index usage is setting the config parameter OPTCOMPIND appropriately. Arun "Monika Rabold S.u.S.E. Linux 5.3" wrote: > Hi, > how can I find out if an index is used? Is there a count in sysindexes or > some where else that is incremented when a certain index of a table is > used in a query plan? > > Thanks in advance > Monika Rabold > > Bull GmbH Langen > Robert Boschstr. 52 > 63225 Langen > > Tel: 06103/761-4225 > Fax: 06103/761-4266 > email: mora@swh600.langen.bull.de

Monika Rabold S.u.S.E. Linux 5.3 — Tue, 6 Apr 1999 14:55:47 -0700 (MST) — source: Informix-list mailing list archive (1991-1998)

Hi, how can I find out if an index is used? Is there a count in sysindexes or some where else that is incremented when a certain index of a table is used in a query plan? Thanks in advance Monika Rabold Bull GmbH Langen Robert Boschstr. 52 63225 Langen Tel: 06103/761-4225 Fax: 06103/761-4266 email: mora@swh600.langen.bull.de