On Monday 10 March 2008, LARC/J.L.Shipman/jshipman <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
