On 11/3/17, Deon Brewis <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
