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]>

Reply via email to