> 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