On Fri, 2005-09-09 at 15:43 -0400, D. Richard Hipp wrote: > There may be something wrong with version 3.2.5. See, for example, > ticket #1414: http://www.sqlite.org/cvstrac/tktview?tn=1414
If you read the comments on the ticket above, you'll see that the problem was solved by running the ANALYZE command which gathers statistics on indices and allows the optimizer to make a more intelligent decision about which indices to use and what order to run the join. There is also a suggestion on how to fake out the optimizer and avoid having to run ANALYZE. I wonder if Mr. Lafleur's problem can be solved in a similar way. -- D. Richard Hipp <[EMAIL PROTECTED]>
