Re: Query Optimizer

Dies ist eine mehrteilige Nachricht im MIME-Format. --------------7BAFAD1E691FD235D6CAD43F Content-Type: text/plain; charset=iso-8859-1 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Content-Transfer-Encoding: 8bit Hello Mauro, but there still exist a lot of chances to tune the Database and force the Optimizer to use a special way by reading queries. Take a look on index and update statistics Mauro G. Pisano schrieb: > 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. > We can't, for the moment, migrate to a new Informix's ON-Line > version. > Thanks in Advance. > > @@@@ @@@@@@@ Mauro G. Pisano > @@@ @@@ @@@ @ Analista Programador. > @@@ @ @ @@@@@@@ Direcc. Gral. de Cultura y Educaci'n. > @@@ @ @@@ - Liquidacion de Sueldos > Transf./EGB - > @@@ @@@ Email: > mpisano@ed.gba.gov.ar --------------7BAFAD1E691FD235D6CAD43F Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Visitenkarte f'r Uwe Christopher Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Uwe Christopher n: Christopher;Uwe org: Triple P adr: Stolbergerstrasse 78;;;K'ln;NRW;50933;Deutschland email;internet: chris@mai-koeln.com title: Softwareengineer tel;work: +49 (0)221-954248-22 tel;fax: +49 (0)221-954248-13 tel;home: +49 (0)221-833695 note: Datenbankentwickler unter Informix x-mozilla-cpt: ;0 x-mozilla-html: FALSE end: vcard --------------7BAFAD1E691FD235D6CAD43F--