Hello!

Is there any way to get estimate number of rows that will be returned by
query (i.e. predicted by optimizer) without actual execution of this query?

In older version it was printed in the output of EXPLAIN statement, but it
looks like it was ommited in v3.8.

Also it looks like API function sqlite3_stmt_scanstatus() might do the job,
but I didn't find any examples of usage, while it requires some good
knowledge of sqlite core. Anyway it is not a preferable because in most
cases this function does not included in release versions of library.

Is there any other ways to grab predicted number of rows?

-- 
Thanks in advance,
Vladimir Belikov.

Reply via email to