Re: ORACLE vs. Informix Performance: What Is Fastest?

Posted in 1995

Bass Chorng — 29 Jun 1995 23:52:48 GMT — source: Informix-list mailing list archive (1991-1998)

DAGMARA@DELPHI.COM (DAGMARA@news.delphi.com) wrote: : My client is running Informix 5.0 on an Intergraph 6850 box under CLIX : 7.5; unfortunately, they are experiencing unacceptable performance. : Intergraph says they are running the same rulebase in Huntsville using : ORACLE 7, and not experiencing any performance problems. Does this sound : legitimate? We are talking about 1.5 hours in Informix vs. several : minutes in ORACLE. : Dagmar Anne Bogan : Kopania & Komerovsky Specializing in Data Architecture : Richardson, TX 75081 and Performance Engineering : dagmara@delphi.com I assume you create tables/indexes and then load data. You need to 'update statistics' after loading, or the index tables are empty.