On Fri, Sep 13, 2013 at 5:29 AM, Ryan Johnson <ryan.john...@cs.utoronto.ca>wrote:
> -- Join cardinality: Bach was a *very* prolific composer whose output > likely dwarfs the (surviving) output of his contemporaries > select p.title, c.name, p.year from composers c join pieces p on p.c_id = > c.id where c.name like '%bach%' and p.year between 1700 and 1750 > How would you mark this even using the suggested function syntax? The likelihood of "c.name like '%bach%' " being true depends on the order the query optimizer decides to evaluate the 2 predicates in, which in turn depends on the likelihood of the predicate! -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
