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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
