On Wed, Sep 18, 2002 at 13:09:07 -0700, Laurette Cisneros <[EMAIL PROTECTED]> wrote: > > Aren't aggregates smart enough to use an index on the column? This takes 8 > minutes to run! I can't see that I should have to build a functional index > (is it possible for an aggregate?) to get this to run faster?
I don't believe a functional index would work for an aggregate. The way to do this is to use an order by clause and a limit 1 clause. This has been discussed a lot on the lists and you should be able to find more details in the archives. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
