On 4/30/2013 5:26 PM, Ryan Johnson wrote:
Being able to force certain access methods (use *this* index, not that one) would be helpful, though (does "+" do that or just suggest it?).
Unary plus turns a simple column reference (for which an index can be used) into an expression (which cannot be indexed). This may be used to suppress the choice of a particular index, at which point the query planner is likely to choose a different index, often rearranging the joins. So the unary plus does often influence the query plan, but in a rather roundabout way.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
