Re: Index doesn't appear to be working.

Frank Bax wrote:
> At 11:02 AM 03/03/02 -0500, Bruce Momjian wrote:
> > Indexes are not automatically used by every query. Indexes are only
> > used if the table is larger than a minimum size, and the index
> > selects only a small percentage of the rows in the table.
>
>
> Shouldn't it say:
> "and the *query* selects only a small percentage..."

Yes, I meant "index returns only a small percentage", but query selects
is better. Thanks.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026