Index: src/analyze.c ================================================================== --- src/analyze.c +++ src/analyze.c @@ -63,11 +63,11 @@ ** about the distribution of keys within an index. The index is identified by ** the "idx" column and the "tbl" column is the name of the table to which ** the index belongs. There are usually 10 rows in the sqlite_stat2 ** table for each index. ** -** The sqlite_stat2 entires for an index that have sampleno between 0 and 9 +** The sqlite_stat2 entries for an index that have sampleno between 0 and 9 ** inclusive are samples of the left-most key value in the index taken at ** evenly spaced points along the index. Let the number of samples be S ** (10 in the standard build) and let C be the number of rows in the index. ** Then the sampled rows are given by: ** @@ -90,11 +90,11 @@ ** the sqlite_stat2 table, with the following changes: (1) ** The sampleno column is removed. (2) Every sample has nEq, nLt, and nDLt ** columns which hold the approximate number of rows in the table that ** exactly match the sample, the approximate number of rows with values ** less than the sample, and the approximate number of distinct key values -** less than the sample, respectively. (3) The number of samples can very +** less than the sample, respectively. (3) The number of samples can vary ** from one table to the next; the sample count does not have to be ** exactly 10 as it is with sqlite_stat2. ** ** The ANALYZE command will typically generate sqlite_stat3 tables ** that contain between 10 and 40 samples which are distributed across