On 10.09.2013 21:26, Richard Hipp wrote:
SURVEY QUESTION:
The question for today is what to call this magic hint function:
(1) unlikely(EXPR)
(2) selective(EXPR)
(3) seldom(EXPR)
(4) seldom_true(EXPR)
(5) usually_not_true(EXPR)
A function call like proposed is much better than adjusting the sql
gramer for implementation details. Therefore this is a better solution.
(6) assume (EXPR, [%value%])
(7) approximate (EXPR, [%value%])
It would be nice to further have a pragma to adjust the probability
expectations of the following query with text involved. I think people
who have to deal with more than one database engine would prefer to use
use such a pragma to adjust such implementation behaviour.
pragma set_text_match_probability %value%
pragma set_pattern_match_probability %value%
Ibrahim
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users