What type of select query would benefit from cluster indexes in SQLITE3 ? If you can, an example would be nice..
I found the following in the wiki, but it doesn't explain much.. Use cluster indexes Clustered indexes are indexes that comprise more than one column. These increase the speed of queries where you have multiple joins of one table or you are selecting rows based on multiple columns. (This is true in other DB systems, I don't know if it holds true in SQLite.)
