-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 15/03/13 05:25, Clemens Ladisch wrote:
> If you had no xBestIndex implementation, SQLite would crash.

He is using APSW (a Python wrapper).  It provides a default implementation
if the developer does not.  Here is the documentation:

  http://apidoc.apsw.googlecode.com/hg/vtable.html#apsw.VTTable.BestIndex

There was some confusion over estimated cost.  APSW leaves it at the
SQLite supplied default which is 1e99 divided by 2.  This generally
encourages to SQLite to use anything else (eg real indices) unless the
developer using APSW knows better.

Roger

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAlFGzgAACgkQmOOfHg372QSzoQCfWxH+ACpo3FbeYFli7DEZVGpO
G+IAn2twe1Lva3sVE05jedQi/7VL3lpk
=CFQH
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to