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
sqlite-users mailing list

Reply via email to