Re: update statistics not recommended!

In article <35D46A64.2BFB@netcomuk.co.uk>, ntruby@netcomuk.co.uk (Neil Truby) wrote: > My new site has a third-party financial package (Lawsons), running on > v7.13. The underlying DBMS is Informix. The Lawsons help desk has told > me that they recommend that we never run UPDATE STATISTICS, as it will > degrade performance. Their reasoning, allegedly based on empirical > evidence of their users, is that all their SQL is written with where > clauses, and the indexes that exist will be used, which is what is > required. If we run an UPDATE STATS, we might risk unexpected and > undesirable access paths. A caveat is added that, under v7.23, some > customers have experienced benefits from an UPDATE STATISTICS LOW, and > that we might run it, but prepared to remove the statistics so derived > if performance nose-dives. > > Well, sounds like bollocks to me, but does anyone else have any views > or, better still, experience of this software packeage running with > Informix? > > Thanks > > Neil > This is some of the best crap I've heard from Lawson in a long time. If you are really worried try and time it, but I'm sure you'll end up ignoring them. Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #