Re: btree unique keys

Posted in 2000

Sujit.Pal@bankofamerica.com — Wed, 12 Jan 2000 10:19:03 -0800 — source: Informix-list mailing list archive (1991-1998)

jparker Check out some tools I submitted to IIUG at: http://www.iiug.org/members/memb_software/archive/utils_sp You will find a tool call idxstat.4gl, which does something close to what you are looking for. HTH Sujit "Parker, J" <JParker@WescoDist.com> on 01/12/2000 05:15:26 AM To: "'informix-list@iiug.org'" <informix-list@iiug.org> cc: Subject: btree unique keys Question: How can a query SMI tables to find out how many unique keys exist for an index including composite indices (all segments)? Background: 1 - pertains to 7.3 Informix Dynamic Server 2 - I'm aware that sysindexes contains the field "nunique" - however this represents the number of unique keys for only the first segment of a composite index 3 - I don't want to pursue using output from "oncheck" since this would be cumbersome Purpose: To be able to identify highly duplicated index keys Thanks for the help. jparker@wescodist.com