Re: Overriding the optimizer

>    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