Thanks Clemens. From: Clemens Ladisch<mailto:clem...@ladisch.de> Sent: 20 May 2017 09:11 To: sqlite-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Index storage space
xTom Byars wrote: > I’m aware that a column value of 1 will use less bytes in an sqlite database > than a value of 4875874568437607. Does this also apply to indexes? Yes; tables and indexes use the same record format <http://www.sqlite.org/fileformat2.html#record_format> in which the integers 0 and 1 have a content size of 0 bytes. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users