On Wed, 03 Jan 2007 12:21:31 +0000 Richard Huxton <dev@xxxxxxxxxxxx> wrote: > Don't forget to cc the list Ok thanks :) > > If you issue "set enable_seqscan = off" before the query that should > force it to use the indexes first. What does that plan show you? I try and then I post the results. Regards Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already is !!!! scotty@xxxxxxxxxxxx - Skype:sscotty71 http://www.linuxtime.it/enricopirozzi