SQLite Forum

What indexes help Window Functions
Thank you, everyone.  Very educational for me.  Since my entire query uses just one table with windows on multiple fields in that table, there doesn't seem to be a way to create an index that will encompass the needs of each of those windows.