Re: Query Optimizer

Posted in 1997

Art S. Kagel — Fri, 26 Sep 1997 12:37:49 -0400 — source: Informix-list mailing list archive (1991-1998)

Mauro G. Pisano wrote: > > HI all: I recently heard about the possibility of upgrade de query optimizer. > I 've got ON-LINE 5.0 and at Informix Seminary, It was listened taht by > upgradin only the query optimizer, somes exposed queries at the seminary, > had down its times from 30 minutes to seconds. > I want to know, If anyone heard something about this points. I would > apreciate very much information about this. We have a system with deal with > some millions of rows per table and we need improve perfomance in queries > because of the time processing that is critical for us. The query optimizer is an integral part of the Informix engine, unlike some un-named database products which need to patch in separate modules for everything, and cannot be broken out and replaced like that. Sorry. Art S. Kagel