On 25 Jun 2011, at 4:12pm, Black, Michael (IS) wrote: > Can the optimizer recognize these "instant" functions and perhaps lean > towards using them?
It already does. That's why max(x) takes no time when you have an index on (x). > Are there cases where this would NOT be good? Theoretically, the optimiser would recognise when this would not be good, and not dp it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users