lundi 5 octobre 2015

What's the number in SQLite query plan mean?

I output the query plan on SQLite, and it shows

 0|0|0|SCAN TABLE t (~500000 rows)

I wonder what is the meaning of the number (500000)? I guess it is the table length, but I executed the query on a small table which does not have so many rows.

Is there any official document about the meaning of the number? thanks.

Aucun commentaire:

Enregistrer un commentaire