Hello, When using a SELECT query with WHERE and GROUP BY clauses, does it make sense to add the GROUP BY terms in an index allready containing the columns used in the WHERE clause ? If yes, should the columns used in the GROUP BY clause be at the beginning of the columns order of the index ?
Many thanks Jean-Marie _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users