L B <[EMAIL PROTECTED]> wrote: > Hi all, > I have this query: > > select CATALOGUES.idcatalogue, CATALOGUES.type, PERSONS.surname, > max(HISTORY.startingfrom) as maxdate > FROM PERSONS > INNER JOIN CATALOGUES > ON CATALOGUES.idperson = PERSONS.idperson > INNER JOIN HISTORY > ON HISTORY.idcatalogue = CATALOGUES.idcatalogue > WHERE CATALOGUES.active='y' > group by PERSON.surname, CATALOGUES.idcatalogue, CATALOGUES.type > > with indexes on: > > PERSONS.surname > PERSONS.idperson > CATALOGUES.active > CATALOGUES.idcatalogue > CATALOGUES.type > HISTORY.idcatalogue > HISTORY.startingfrom
Try adding an index on CATALOGUES.idperson Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
