Re: Tetra and Update Statistics

Here in OZ we use CS3 (another tetra package) on an informix databse (IDS 7.3) I update statistics EVERY night otherwise CS3 will be a dog !! It sound like your tetra consultant has NO idea about informix databases. This dosnt surpise me.. the clowns here have no idea as well !! "Andrew Hamm" <ahamm@mail.com> wrote in message news:bgupc4$r2f70$1@ID-79573.news.uni-berlin.de... > Paul Watson wrote: > > I haven't used Tetra Accounts for a number of years now and I've > > recently inherited a site that uses Tetra 3.1 and it's running > > slow, everything points to update statistcs but the Tetra supplier > > is saying "don't run update statistics". AFAIR this never used to be > > the case. Anybody got any upto date views on this. > > YER JOKING! > > Not even low? If there are indexes, then it *surely* needs to know at least > how many frikken rows there are in the table instead of zero. > > I say, try at least a low. If it goes tits-up, u can always zero out the > stats again. > > I briefly "interfaced" with Tetra 15 years ago, and I seem to recall it had > fairly standard style table definitions. Can you get them to elaborate on > what they think will go wrong with the stats? > >