On Monday 10 March 2008, LARC/J.L.Shipman/jshipman
<jeffery.l.shipman@nasa.gov> wrote:
> Hi,
> When I do a search such as:
>
> 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?
>
You asked for the whole table. How would an index help?
--
Alan