Re: Overriding the optimizer

Christopher Kings-Lynne 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)

Thanks, but myfunc() takes parameters (shown here as "foo, bar"), one of which is not a column, it's external and
changeswith every query.  A function index won't work. 

Craig