Re: Query Retrieval

Posted in 1996

Nils Myklebust — Thu, 03 Oct 1996 05:19:37 GMT — source: Informix-list mailing list archive (1991-1998)

Srirama Sundararajan Rajagopalan <rajagopa@nps.med.ge.com> wrote: :Hi Folks: :I am working on improving the query performance in informix 7.1. :I already have unique indexing on this table and besides optimizing :the query, virtual processor technique, is there any other technique :that can be employed to improve the query retrival time in informix. Update statistics, fragmentation, PDQ, read ahead, buffer size inengine. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org