On Thu, Nov 29, 2007 at 01:26:00PM +0000, Pedro Doria Meunier wrote: > Hi People. > > I need some help optimizing this query: <snip> > I still get Seq Scans although all used fields are indexed, hence the > time used... :-( A seq scan on a table with 10 rows is *good*. An index would take longer. What you really need is to send the output of EXPLAIN ANALYZE so we can see where the time actually went. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Those who make peaceful revolution impossible will make violent revolution inevitable. > -- John F Kennedy
Attachment:
signature.asc
Description: Digital signature
