Postgres Pro
Downloads
Home   >   mailing lists

create index on function - why? - Mailing list pgsql-sql

From Wei Weng
Subject create index on function - why?
Date
Msg-id 3C6D3684.9040101@kencast.com
Whole thread Raw
Responses Re: create index on function - why?  ("Nick Fankhauser" <nickf@ontko.com>)
Re: create index on function - why?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: create index on function - why?  (Bruno Wolff III <bruno@wolff.to>)
Re: create index on function - why?  (Bruce Momjian <root@candle.pha.pa.us>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: creating an index on a function
Next
From: "Nick Fankhauser"
Date:
Subject: Re: creating an index on a function