On 22 Mar 2018, at 10:16pm, Mark Wagner <[email protected]> wrote:
> Curious about the suggestion of adding + to the order by first term.
This stops SQLite from realising it can use an existing index. If you do
CREATE INDEX m_s ON members (score)
SELECT * FROM members ORDER BY score DESC
SQLite cleverly spots that the index is useful. However
SELECT * FROM members ORDER BY +score DESC
has SQLite looking for "+score" but find "score", and they are clearly
different, so SQLite will not use index m_s.
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
