Path: utzoo!utgpu!watmath!clyde!att!osu-cis!tut.cis.ohio-state.edu!mailrus!ncar!ames!oliveb!pyramid!infmx!davek
From: davek@infmx.UUCP (David Kosenko)
Newsgroups: comp.databases
Subject: Re: need HELP with index problem
Summary: errata
Keywords: index informix
Message-ID: <711@infmx.UUCP>
Date: 27 Dec 88 18:11:29 GMT
References: <8973@cit-vax.Caltech.Edu> <710@infmx.UUCP>
Organization: Informix Software Inc., Menlo Park, CA.
Lines: 14

In article <710@infmx.UUCP>, davek@infmx.UUCP (David Kosenko) writes:
> 	An index on a field that has 90% duplicate entries is only
> useful when accessing (or updating) records where the value is other
> than that field; the index can be used to get to the record quickly.
            ^^^^^ this should be "value" (i.e., 0), not "field"

My apologies for the flub.

Dave
-- 
Disclaimer:  The opinions expressed herein |"As we hang beneath the heavens
are by no means those of Informix Software | and we hover over hell
(though they make you wonder about the     | our hearts become the instruments
 strange people they hire).                | we learn to play so well"