On 1/28/18, Deon Brewis <de...@outlook.com> wrote:
> Sorry, wrong table, should be:
>
> CREATE INDEX FooBar ON Foo(Bar(GuidId));
>
> It's an expression-based index. But I doubt that has anything to do with it.
> Can probably just be:
>
> CREATE INDEX FooBar ON Foo(GuidId);

Can you send the output of sqlite3_analyzer for your database so that
we can compare the actual table and index sizes?

-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to