Thread: functional indexes instead of regular index on field(s)?

Hello!

    How much does planner take into consideration index size? Can one help
planner use indexes by having several functional indexes which should be
smaller  instead of one bigger index which covers whole range of values per
field(s)?

Thanks in advance.

On Mon, Jun 16, 2003 at 19:38:19 +0200,
  Tomaz Borstnar <tomaz.borstnar@over.net> wrote:
> Hello!
>
>     How much does planner take into consideration index size? Can one
>     help planner use indexes by having several functional indexes which should
> be smaller  instead of one bigger index which covers whole range of values
> per field(s)?

This sounds more like partial indexes than functional indexes.