NO_KEYFIRST environment variable

Posted in 2000

Dbsv — 14 Feb 2000 19:53:19 GMT — source: Informix-list mailing list archive (1991-1998)

Hello out there, Has anyone experienced the use of the NO_KEYFIRST environment variable. What is its use? How do you use it? What are the advantages and drawbacks when it is used? Thanx in advance for the answers. K.B khaledb@aol.com

↪ replying to Dbsv

David Williams — Wed, 16 Feb 2000 00:06:49 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <20000214145319.01560.00001111@ng-fp1.aol.com>, Dbsv <dbsv@aol.com> writes >Hello out there, > > >Has anyone experienced the use of the NO_KEYFIRST environment variable. > >What is its use? > It disables KEYFIRST scans, a new way of using indexes. Was need due to a bug in Online where Keyfirst scans did not work. Not required under 7.31.UC4. >How do you use it? > export NO_KEYFIRST=1 then start online. >What are the advantages and drawbacks when it is used? > It is a workaround for a bug. Should not be required if you upgrade to Informix Dynamic Server 7.31. (7.31.UC5 is the latest). > >Thanx in advance for the answers. > > > >K.B > >khaledb@aol.com -- David Williams