> You can create a new table using 'create table as' to produce your
> target results. This is real fast ...
> I often see 2 orders of magnitude improvement doing this, and no
> need to vacuum.
Indeed:
"Query returned successfully with no result in 582761 ms."
Though I must say, ten minutes is nominally more than two orders of
mangitude performance improvement, versus several days.
Many thanks, Aaron.
/rls
--
Rosser Schwarz
Total Card, Inc.