That sounds a bit more reasonable! Glad it worked out OK.
--
View my Linkedin profile <http://uk.linkedin.com/in/matthewdwalden>
> Thanks, I did just that after some consideration. I ran the query in
> various
> combinations and permutations to see what was fastest.
>
> on the 18000 documents in the table it reduced the time from 30 seconds
> down
> to 600msec which is acceptable to me - to pull out say all the documents
> imported in the last month.
>
> Thanks for taking the time to reply.
>