Re: Query Planner GROUP BY and HAVING clauses optimization ?
Jean-Baptiste Gardette <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
Just to be sure, is it unsafe to write a non agregate SELECT with GROUP BY and HAVING clauses (without sub-SELECT) for the sole prupose explained before (even if the approache is discutable) ? I understand 2 different answers here : - "No, this kind of query can't be rewritten by the optimizer for the technical reasons (VDBE, index etc)" - "Yes it is unsafe, a future version of SQLite may optimize differently this kind of query" I can't see something related to my problem in the doc https://sqlite.org/optoverview.html _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users