Jean-Paul Calderone <[EMAIL PROTECTED]> wrote: > I've hit a case where SQLite is selecting a suboptimal index for my query and > I want to do something to tell it to use a different index. I'm familiar > with the "+" trick to confuse the optimizer but I can't see how it would > apply to this case. > > > Is there any way to convince SQLite to use the index I want? >
The deficiency you have found in the optimizer is known to me. I just haven't had the opportunity to fix it. Usually if you run ANALYZE after putting some data in to the database, the problem goes away. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------