Steve Green <[EMAIL PROTECTED]> wrote: > the unary + operator in front of the two utime terms did cause the optimal > index to be used... Can you explain why this works?
A unary + in front of a column name disqualifies the term from consideration by the optimizer, and hence from use by indices. That left the other index as the only choice. > > What is the best way to send you sample data (and what is the maximum > file size that you'd like)? > Actually, if you could just send me your schema and the query that is causing problems by private email, I can probably use that to figure out why the optimizer is failing so badly in this case. -- D. Richard Hipp <[EMAIL PROTECTED]>