Hello everyone,
I had 2 questions: 1) Given the query: SELECT col1 FROM table WHERE col2 = ? GROUP BY col3, col4 ORDER BY col5, col6, col7, col8; What would be the "right" index to create? I was thinking it would be: CREATE INDEX index1 ON table (col2, col3, col4, col5, col6, col7, col8); Running an EXPLAIN QUERY PLAN indicates that this index is in fact used. However, what I cannot decipher from the VBDE codes from EXPLAIN is whether it is used fully to satisfy the entire query or is it used to only satisfy part of the query. 2) If there are no aggregates column present in a query, are GROUP BY essentially ORDER BYs semantically? (such as in the query above) Thanks a lot folks! Aly Hirani _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
