-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Sylvain Pointeau wrote: > how do we know that we are using an optimal index in a query?
How do you know if you are not? The point of an index is to avoid visiting every row in a table while evaluating an expression, so generally the best index is one that scans the least number of rows. Here are some terms you can search the mailing list and website for in order to get a better idea: explain query plan analyze SQLITE_ENABLE_STAT2 sqlite3_stmt_status Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkrv+qIACgkQmOOfHg372QQ7QQCgpRXDvXD8gxUy3IBLFnIM08mH ZpYAn025UIO0TJQqviWY0+hiWkGgsCBU =ZdZl -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users