How about:
maybe(COLUMN LIKE '%pattern%',.95)
or (as percent using integer value in 0..100)
maybe(COLUMN LIKE '%pattern%',95)
with a default value of (possibly) 50% (or .5) for the optional second arg?
-----Original Message-----
From: Richard Hipp
Sent: Tuesday, September 10, 2013 10:26 PM
To: General Discussion of SQLite Database
Subject: [sqlite] Hints for the query planner
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)
Please feel free to suggest other names if you think of any.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
