> 3.5 minutes compared to 15 secs IS NOT TOO LONG!?! I would love to
> see how your customer react when they take such a hht in performance!
>
> And stop making assumptions about client/server mindsets.
>
> >I cannot understand why anyone would
> > want to run a statement without a where clause on a million-row
> table
> > (well, possibly if there were some kind of grouping reducing the
> > returned set to a few rows)
>
> My query does only return a few records from the table, I'm using
> a 'distinct' clause.
>

You are right, I think the index structures of FB do not handle such poor
selectivity well (i.e. 5 distinct records types over 2.1 million records)
Alan