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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
