create index on function - why?

From: Wei Weng <wweng(at)kencast(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: create index on function - why?
Date: 2002-02-15 16:25:40
Message-ID: 3C6D3684.9040101@kencast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I can understand the rationale behind creating index on tables, it
speeds up the searching.

But what is the rationale behind creating index on a function? how does
it help with the database performance?

Thank you.

--
Wei Weng
Network Software Engineer
KenCast Inc.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Nick Fankhauser 2002-02-15 16:27:57 Re: creating an index on a function
Previous Message Tom Lane 2002-02-15 16:00:11 Re: creating an index on a function