[sqlite] index optimization

[galeazzi]

Hi,
if I've got a lot of queries as follows:
SELECT id,title FROM Song WHERE title >= 'last_title' AND  
(title>'last_title' OR id>last_id) ORDER BY title ASC, id ASC
what's the best index should be created? (id is the key);
I red that I can only use a multicolumn index if the left condition is  
equal (=), is it true?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users