[update statistics & syscolumns]

Posted in 1999

Yang, Heung-Soon — Fri, 30 Jul 1999 09:08:39 +0900 — source: Informix-list mailing list archive (1991-1998)

Hi, I am supporting IDS 7.24UC4 on HP-UX 10.20. It is recently upgraded from 7.23. After upgrade, some queries are slower than previous version because of changed query path. So, I 'update statistics high' for some table, but nothing changes. I looked up the syscolumns table, and 'dbschema -d dbname -t tabname -hd tabname'. And I found the table has null value in syscolumns(colmax,colmin) iver all columns and the distribution information was totally incorrect despite of "update statistics high". And the table has several indexed columns with null value in syscolumns(colmax,colmin) Could you please help me? Thanks in advance..