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 changes with every query. A function index won't work.
Craig