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