Re: Index doesn't appear to be working. - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Index doesn't appear to be working.
Date
Msg-id 200203031836.g23IaAl15256@candle.pha.pa.us
Whole thread Raw
In response to Re: Index doesn't appear to be working.  (Frank Bax <fbax@sympatico.ca>)
List pgsql-sql
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@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: Frank Bax
Date:
Subject: Re: Index doesn't appear to be working.
Next
From: "John Oakes"
Date:
Subject: - Finding records in sequence