On Fri, Sep 2, 2016 at 5:51 PM, Richard Hipp <d...@sqlite.org> wrote:
> On 9/2/16, Dominique Devienne <ddevie...@gmail.com> wrote: > > > > For example, we use Guid extensively, which are typed blob, but often > > add that CHECK(length(guid) = 16) constraint. I know 20 is not far off > > from 16 in this particular case, but more accurate is always better, no? > > The difference between 16 and 20 won't matter here. What you have is fine. > > 16 versus 1600 might matter a little. 16 versus 20 will not. Thanks. I take that as a no to my "will it use length-check-constraint" question :). Does ANALYZE gather actual statistics on lengths? Meaning that the datatype length heuristic you described is used only when there are no stats available, right? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
