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
