Roger Binns wrote: > SQLite provides you the tools to find out for yourself. In the shell do > '.explain' and then give it your query prefixed with 'EXPLAIN'. You'll get > the virtual db engine code for the query printed out. > ... > In answer to your question, yes the index is used. You can see instructions > prefixed by Idx that aren't there when the index doesn't exist.
Roger, thank you! The EXPLAIN feature opens a whole new world to me. How fascinating. Thanks again, -- Dan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
