Re: Overriding the optimizer

[Jaime Casanova <systemguards@xxxxxxxxx>]

On 12/15/05, Christopher Kings-Lynne <chriskl@xxxxxxxxxxxxxxxxxxx> wrote:
> >    select * from my_table     where row_num >= 50000 and row_num < 100000
> >     and myfunc(foo, bar);
>
> You just create an index on myfunc(foo, bar)
>
> Chris
>

only if myfunc(foo, bar) is immutable...

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)