Jim Dodgen <[EMAIL PROTECTED]> wrote:
>
> 2. get the optimizer to ignore indexes that I know cannot help
>
> I do this in the where clause, by adding a zero or concatenating a ""
> depending upon the data type
>
> examples:
>
> where sex = "M"
> changed to
> where sex||"" = "M"
It is more efficient to use a unary + operator, like this:
where +sex = 'M'
The unary + is a no-op (no code is generated for it) but it
does disqualify the column it prepends to for use in an index
just like the || operator.
