Re: Overriding the optimizer - Mailing list pgsql-performance

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 ;)