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