SQLite Forum

Should SQLite be able to optimize this query?
Login
My hunch is that you'll find that exact case with group_concat() a lot in the wild because we can't do ordered aggregates.

Adding in the ability to do

> group_concat(word, ',' order by word)

would allow people to fix it, but then they'd be fixing it because it broke in the meantime.