Hello, In a SELECT statement with multiple tables, is it possible to replace WHERE clauses used to avoid cross joins with GROUP BY + HAVING clauses (with the same criteria) for the same purpose (no cross join) ?
Are the two methods roughly equivalent in performance ? We ask this because we wonder why using the GROUP BY + HAVING solution with 7 tables instead of WHERE clauses we see big degradation of perforamnce (0,5 seconds against 30 minutes) + break with "disk full" error message . We checked the statement with GROUP BY + HAVING against the initial WHERE clause and are assured not to "miss" any criteria present in the WHERE clause. Thanks Jean-Marie _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
