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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly