Re: Tetra and Update Statistics

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. > > BTW Informix 7.31 HPUX 11 Which database server? As Malcolm says, the old Tetra systems were written in C-ISAM. Then when they needed SQL access, they installed SE and manually created and mapped tables to the C-ISAM files. I think the problem with doing anything that updated the system tables was it could cause these links to be broken. However, AFAIK (I have only ever seen Tetra/Chameleon briefly, so am far from knowledgeable) from C2000 they started using ESQL/C instead of C-ISAM and could therefore use any Informix database server. So if you are using "real" (not C-ISAM) Informix database storage then I would agree that UPDATE STATS should be run. With some of these in-house rules, they are often followed religiously without any knowledge of why they were originally required. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list