Dirk Moolman said:
>
> -----Original Message-----
> From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
> On Behalf Of Obnoxio The Clown
> Sent: 05 December 2005 03:31 PM
>
>
>>Have you tried UPDATE STATISTICS?
>
>
> As long as you don't ask this to the people in my company. The 4GL
> programmers (including our "software manager"), have no faith in update
> statistics, and Informix - they keep telling me how bad IDS is, and
> blame a lot of issues on update statistics (probably need an excuse to
> pass the buck).
Ah! Old-school programmers. Still used to SE and accessing things by
ROWID, eh?
Tell you what, why not offload a couple of these issues on me, free of
charge, for my impartial advice and comment, since I know IDS and 4GL (and
SE)?
--
Bye now,
Obnoxio
"C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule"
- Coluche
did i mention i like nulls? heck, i even go so far as to say that all
columns in a table except the primary key could/should be nullable. this
has certain advantages, for example, if you need to insert a child record
and you don't have a parent row for it, just do an insert into the parent
table with the primary key value (everything else null), and voila,
relational integrity is preserved. but this is, admittedly, a bit
controversial among modellers.
--r937, dbforums.com
sending to informix-list