On Thu, Oct 22, 2009 at 12:34:26AM +0200, Sylvain Pointeau wrote: > if your "book" contains all lines (a,b,c,t,d)and you create an index on > (a,b,c,t) > > then your index is as fat as your book, isn't it?
Depends on the size of d. Also, if you add a constraint declaring t, a, b, and c (you want 't' first!) to be unique then the DB could make the whole thing smaller than if you first create the table, then the index. (I'm not sure of SQLite3 does that, but it could). Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
