|
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? 757-864-7114 LARC/J.L.Shipman/jshipman |
