Re: Using max() MUCH slower in v7.1

On Wednesday 17 January 2001 12:29, Tom Lane wrote:
> "Gordan Bobic" <gordan(at)freeuk(dot)com> writes:
> > CREATE VIEW LastDate AS
> > SELECT Company,
> > max(Date) AS Date
> > FROM PastInvoices
> > GROUP BY Company;
> >
> > And then call it like
> > SELECT Date FROM LastDate ORDER BY Date WHERE Company = 'SomeCompany';
> >
> > It takes ABSOLUTELY forever. The table has about 25-30M records.

As long as you are selecting a specific company with that WHERE clause,
isn't that ORDER BY unnecessary?

--
-------- Robert B. Easter reaster(at)comptechnews(dot)com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------