On 1/14/16, ???????? ??????? <belikov.vl at gmail.com> wrote: > 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? >
Nope. sqlite3_stmt_scanstatus(pStmt, SQLITE_SCANSTAT_EST, ...) is your only option. Why do you want this information? -- D. Richard Hipp drh at sqlite.org
