On 23 May 2014, at 1:26pm, Török Edwin <[email protected]> wrote:

> Also it might be nice to show a message (or a warning via SQLITE_CONFIG_LOG) 
> when you run 'explain query plan'
> and there are indexes (either manual or implicit), but they were rejected for 
> "some reason".

The index that was rejected might be useful for a different SELECT.

The index that was rejected might be used when the amount of rows in the table 
change: comparison of number of rows in two related tables can change which 
index is the most useful.

Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to