On 10/14/2014 3:51 AM, Mark Lawrence wrote:
On Tue Oct 14, 2014 at 09:25:20AM +0200, RSmith wrote:
To get even more compact, I would go with Igor's SQL which ... will run quite a 
bit slower

I'm a little curious about why you say a CTE statement is slower than a
VIEW for large tables.

My query uses neither views nor CTE. I'm a little curious about how a comment on the former could be construed to reflect in any way on the latter.
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to