[GENERAL] searching using indexes 8.3

2008-03-10 Thread LARC/J . L . Shipman/jshipman
Hi, When I do a search such as: EXPLAIN ANALYZE SELECT * FROM itemsbyauthor; QUERY PLAN --- Seq Scan on itemsbyauthor

Re: [GENERAL] searching using indexes 8.3

2008-03-10 Thread Richard Huxton
LARC/J.L.Shipman/jshipman wrote: EXPLAIN ANALYZE SELECT * FROM itemsbyauthor; QUERY PLAN --- Seq Scan on itemsbyauthor

Re: [GENERAL] searching using indexes 8.3

2008-03-10 Thread Alan Hodgson
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

Re: [GENERAL] searching using indexes 8.3

2008-03-10 Thread Alban Hertroys
On Mar 10, 2008, at 6:33 PM, LARC/J.L.Shipman/jshipman wrote: Hi, When I do a search such as: EXPLAIN ANALYZE SELECT * FROM itemsbyauthor; QUERY PLAN --