indexing - What has changed in sqlite3 so that the query plan does not show the estimated number of rows anymore? -
in version 3.7.8 query plan looked like
scan table cities (~1000000 rows) search table postalcodes using integer primary key (rowid=?) (~1 rows) but 3.8.10.2 is
scan table cities search table postalcodes using covering index sqlite_autoindex_postalcodes_1 (postalcode=?) what has changed? can somehow configure shows estimated number of rows again?
what has changed query planner rewritten. during that, printing of number of rows removed.
this cannot reconfigured.
Comments
Post a Comment