Hi, The following text appears in section 1.1 of eqp.html:
> For example, the following EXPLAIN QUERY PLAN command operates on a SELECT > statement that is implemented by performing a full-table scan on table t1: > > sqlite> EXPLAIN QUERY PLAN SELECT a, b FROM t1 WHERE a=1; > 0|0|0|SCAN TABLE t1 (~100000 rows) > > The example above shows SQLite estimating that the full-table scan will visit > approximately 1,000,000 records. Note the numerical inconsistency between the example EXPLAIN output ("~100000") and the text that follows ("approximately 1,000,000"). Thanks, Richard _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users