On 1/28/18, Deon Brewis <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
