0

In version 3.7.8 the query plan looked like

SCAN TABLE Cities (~1000000 rows)
SEARCH TABLE PostalCodes USING INTEGER PRIMARY KEY (rowid=?) (~1 rows)

but with 3.8.10.2 it is

SCAN TABLE Cities
SEARCH TABLE PostalCodes USING COVERING INDEX sqlite_autoindex_PostalCodes_1 (PostalCode=?)

What has changed? Can I somehow configure that it shows the estimated number of rows again?

Fabian
  • 4,001
  • 4
  • 28
  • 59

1 Answers1

0

What has changed is that the query planner was rewritten. During that, the printing of the number of rows was removed.

This cannot be reconfigured.

CL.
  • 173,858
  • 17
  • 217
  • 259