On 12/15/05, Christopher Kings-Lynne <chriskl@familyhealth.com.au> 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)
>
> Chris
>
only if myfunc(foo, bar) is immutable...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)