hello, can you describe an output of a "explain"? for me it is hard to read and to analyze the output.
is there something to tell us the best index to have for a specified query? best regards, Sylvain On Tue, Nov 3, 2009 at 10:40 AM, Roger Binns <rog...@rogerbinns.com> wrote: > -----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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
