Re: Performance problem

Posted in 1998

Srinivasulun@hotmail.com — Thu, 11 Jun 1998 03:49:23 GMT — source: Informix-list mailing list archive (1991-1998)

You may need do 'update statistics' on the slower database In article <357E8842.EB2CE585@vtt.fi>, timo.h.jarvinen@vtt.fi wrote: > > Hi, > > We have two almost identical ODS 7.23 databases on NT 4.0 Servers. The > schemas are exactly identical. However, when making a complex query, the > other one is 50% slower. The faster database has more data than the > slower one. No indexes are created on the databases, only primary keys > are used. > > The results of SET EXPLAIN: > Estimated Cost: 1224 (590) > Estimated # of Rows Returned: 549 (9) > > Any idea what may be the reason for the difference? > > -- > Timo H Jarvinen > VTT Technical Research Centre of Finland > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading