Performance problem

Posted in 1998

Timo H Jarvinen — Wed, 10 Jun 1998 16:21:06 +0300 — source: Informix-list mailing list archive (1991-1998)

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