Jim Dodgen <[EMAIL PROTECTED]> wrote: > one simple trick I first started using with oracle and also use with > sqlite is to do the following on the where clause > for numerics > where filda = fldb+0 > > for strings > > where flda = fldb||"" > > this would cause a index on fldb to be ignored during optimization >
That trick works, but it imposes a run-time overhead because SQLite actually has to evaluate the +0 and the ||"". If you just say: where filda = +flda The unary "+" operator is a no-op in SQLite, it works with both numbers and strings, and there is no run-time penalty (other than the fact that an index will not be used.) On the other hand, I have no idea if oracle supports a unary "+" operator or not. -- D. Richard Hipp <[EMAIL PROTECTED]>
