On Wed, 15 Nov 2006 03:28:50 +0000, [EMAIL PROTECTED] wrote:
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.
Alright, thanks.
Jean-Paul
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
