Re: Performance problems with Online 5.03.UC1

In article <4b76v9$mki@cssun.mathcs.emory.edu>, m.mejia@server1.codetel.net.do' says... >I have Informix-Online 5.05.UC1 running on UNISYS/SVR4, recently I have been >several performance problems. I have a table with 85,000 rows aprox. and all >the indexes look right for me. I already run UPDATE STATISTICS, tbcheck -ci, >tbcheck -cI. First, which is it? 5.03 or 5.05? (subject is one, body of message is the other.) Second, Informix has a long-outstanding bug with respect to systables.npused - you might check to see whether npused for this table is negative. If it is, then manually update it to some rational value. (There have been some scripts posted to this group that also do this; should be available at the archive sites.) -- William Harris (Standard disclaimers) CARS Information Systems 4000 Executive Park Drive Cincinnati, OH (USA) 45241