Sysindexes - column defs

Posted in 1996

Steve Goldberg — 26 Aug 1996 01:49:21 GMT — source: Informix-list mailing list archive (1991-1998)

I am wondering what is the meaning of the last columns in the sysindexes table: levels, leaves, clust and nunique. I am having possible speed problems between 2 databases (one has 160K records, the other 560K records). Same search using the same indexes has considerably different speeds. I have RTFM but can't find anything on these columns. Solaris OS, Online 5. Any thoughts would be appreciated. TIA Steve Goldberg Landata RE-Source Houston