On 11/3/17, Deon Brewis <de...@outlook.com> wrote: > > Is there a way that I can view the cost metrics that goes into each query > plan choice to see how it calculates the best index? >
(1) Get a copy of the canonical source tarball (2) ./configure --enable-debug; make (3) ./sqlite3 $yourdatabase (4) At the "sqlite>" prompt, type ".wheretrace 0xfff". (5) Enter your query The 0xfff is a mask of different things to be traced. You have to refer to the source code to decode the mask. There is no documentation explaining the output of .wheretrace. The output of .wheretrace is subject to change. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users