"Andrea Galeazzi" <[email protected]> wrote in message news:[email protected] > I meant: > SELECT title FROM tracks > WHERE title >= :last_title AND > (title>:last_title OR id>:last_id) AND title LIKE %Mad% > ORDER BY title,id; > better than > SELECT title FROM tracks > WHERE title LIKE %Mad% AND > title >= :last_title AND > (title>:last_title OR id>:last_id) > ORDER BY title,id; > > ?
These two should be equivalent. > Furthermore > can the index improve select performance in both previous > cases? Yes, an index on (title, id) should help in both cases. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
