> BTW : Having said that FBI's arent clever, I note that
>
> select *
> from mytab
> where somefunc( 4* col1 ) > 2000;
>
> Actually *does* use myidx, so the FBI definition does not alway have
> to match the where clause exactly.
>
> Funny enough :
>
> select *
> from mytab
> where somefunc( col1 * 2 * 2 ) > 2000;
>
> will not use mydix, but this one will
>
> select *
> from mytab
> where somefunc( col1 * (2 * 2) ) > 2000;
>
> The cleverness of FBI's seems limited, so I wouldn't count on it. Any
> opinions, anyone ?
Yes, I guess the CREATE INDEX statement should read
create index myidx on mytab(somefunc(col1 * 4));
instead of
create index myidx on mytab(col1 * 4)
Received on Sun Jan 11 2004 - 17:43:00 CST
