Re: Index reporting wrong field???

Posted in 1996

Cheryl Kendricks — 4 Jun 1996 21:13:17 -0400 — source: Informix-list mailing list archive (1991-1998)

Have you done an "update statistics HIGH"? ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On 12 Mar 1996, JohnEmcRx wrote: > I am running informix 7.12 on an SCO box on one of the tables in my db > when I do an info index I get a list of indexes the index names are > correct some times but the columns are never correct. However when I look > at the indexs in the sysmaster database the report as being correct. They > do seem to be work fine though as well. does any one have an idea as to > what this problem could be. Thanks for any help given > John. >