[sqlite] Retriev estimate number of rows returned by query

[Simon Slavin]

On 14 Jan 2016, at 1:28pm, ???????? ??????? <belikov.vl at gmail.com> wrote:

> 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?

I don't know of one.

Of course, you can execute the query with the requested columns replaced with 
"count(*)":

SELECT a,b,c,d,e FROM myTable WHERE b<c+e ORDER BY a

becomes

SELECT count(*) FROM myTable WHERE b<c+e ORDER BY a

This will give you the number of rows returned.  It'll be slow but it'll work.

Simon.