On 19 Aug 2009, at 12:01am, yaconsult wrote: > Simon, > > Thank you for the optimization. I'll switch to using between. This > particular database is used for generating some statistics and > generating > reports, so performance is not that big an issue.
DRH's post trumps mine, of course. I'm surprised to find that brackets are optimised out of WHERE evaluations. In my defence I did mention EXPLAIN, which is the way to find this stuff out for yourself. > When you talk about "clever use of an index", are you referring to a > combined index or merely indices on each column? SQLite is good at working out the minimum amount of work to do to find your results. I thought that your second form would give it more leeway to be clever than the one with brackets. But it turns out I was wrong. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
