On Tue, Dec 18, 2007 at 12:24:25PM +0000, Simon Davies wrote: > Prob shd be http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
One question - using the example mentioned there: If we've created an index: CREATE INDEX example1 ON tracks(singer, title); So, it'll make the query, like below, much faster: SELECT title FROM tracks WHERE singer='Madonna' AND title<:firsttitle ORDER BY title DESC LIMIT 5; ...but I understand, that when I'll try to add in the query a field not covered by index "example1", like this: SELECT title FROM tracks WHERE singer='Madonna' AND title<:firsttitle AND year_ed > 1985; ...so, then I'm losing every profit from having "example1" index, right? Or perhaps "not quite every", and some speedup still remains - just because _some_ columns are covered by example1 anyway? -- pozdrawiam / regards Zbigniew Baniewski ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------