On Tue, Mar 29, 2005 at 14:21:15 +0100, T E Schmitz <[EMAIL PROTECTED]> wrote: > > As far as I can see (via EXPLAIN), both DISTINCT and GROUP BY will lead > to a sequentail scan. Is that correct?
If you need to read the whole table yes. However if you join the view to something else that might not be necessary. > If that's the case, I should come up with a different concept to obtain > a list of ORIGINs. That may be a good idea, especially if there are lots of rows for each origin value. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
