Take a look at the slide show from the PHP conference, available at sqlite.org. It gives a good explanation of how SQLite uses indices, starting around the 40th or 50th slide.
BTW, 'cluster index' is probably not the right term. That usually means a common index on a cluster of tables. SQLite doesn't do clustering, but it can sometimes use a multi-column index to advantage. Regards
