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

Reply via email to