Hi, On Mon, Apr 13, 2009 at 12:40 AM, Tito Ciuro <tci...@mac.com> wrote: > One question, when I run the command I see that the fragmentation in > "All tables" is greater than "All tables and indices". How can that > be? The sum of all tables and their indices doesn't add up (10.6% + > 7.5% ≠ 9.6%):
From the given information: All tables Percentage of total database.......... 66.4% Fragmentation......................... 10.6% All indices Percentage of total database.......... 33.6% Fragmentation......................... 7.5% Now, 0.664 * 10.6 + 0.336 * 7.5 = 9.5584 This rounds to 9.6, which corresponds to: All tables and indices Fragmentation......................... 9.6% Regards, Eugene Wee _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
