[sqlite] query Benchmark

[Simon Slavin]

On 12 Feb 2016, at 10:14am, Michele Pradella <michele.pradella at selea.com> 
wrote:

> I can make the query:
> SELECT field FROM car_plates WHERE (field>='EX011A')AND(field<='EX011Z');
> now I can use the index the query is faster.

SQLite makes this optimization for you.  See section 4.0 of

<https://www.sqlite.org/optoverview.html>

Simon.