| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "LARC/J(dot)L(dot)Shipman/jshipman" <jeffery(dot)l(dot)shipman(at)nasa(dot)gov> |
| Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: searching using indexes 8.3 |
| Date: | 2008-03-10 17:40:02 |
| Message-ID: | 47D57272.9030506@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
LARC/J.L.Shipman/jshipman wrote:
> EXPLAIN ANALYZE SELECT * FROM itemsbyauthor;
> QUERY PLAN
> -------------------------------------------------------------------------------------------------------------------
>
> Seq Scan on itemsbyauthor (cost=0.00..971.34 rows=53634 width=34)
> (actual time=0.029..25.831 rows=53634 loops=1)
> Total runtime: 34.851 ms
> (2 rows)
>
>
> I have an index for the table, but it is not being utilized. Why is
> this? How do I get the index to be used?
An index to fetch all the rows from a table? How would that help?
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2008-03-10 17:42:58 | Re: searching using indexes 8.3 |
| Previous Message | LARC/J.L.Shipman/jshipman | 2008-03-10 17:33:04 | searching using indexes 8.3 |