Re: [sqlite] ignore index

It would be even better if SQLite could do a better job at optimizing the index searches. __ Raymond Irving --- rene <[EMAIL PROTECTED]> wrote: > Hi, > > i ran into a simulair case as this message > http://www.mail-archive.com/[EMAIL PROTECTED]/msg01646.html > > where an index actually slows t

[sqlite] ignore index

Hi, i ran into a simulair case as this message http://www.mail-archive.com/[EMAIL PROTECTED]/msg01646.html where an index actually slows things down, because there are many rows matching the condition (where the other (indexed) condition only matches a few rows). In above mentioned letter you su