On Fri, Mar 14, 2014 at 4:51 PM, Richard Hipp <d...@sqlite.org> wrote:
>> > In the original problem, there was already an index on the term for which > the min() was requested. >..... > Whit your CTE-generated random integers, there is not an index on the > values. So "SELECT min(x) FROM..." does a linear search and "SELECT x FROM > ... ORDER BY x LIMIT 1" does a sort. > I see, my fault, didn't notice the db was a concrete one _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users