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

From Luis Sousa
Subject Re: create index on function - why?
Date
Msg-id 3C6D43EB.5040201@ualg.pt
Whole thread Raw
In response to create index on function - why?  (Wei Weng <wweng@kencast.com>)
List pgsql-sql
Can you give an example of it ??

I have some problems of perfomance in my queries, probably if I use this 
idea I could increase performance.
I already explore all the index in the tables that are used in the queries.

Luis Sousa

>
>If a where clause includes a function reference, than an index on that
>function can speed up finding rows that satisfy the where clause.
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>





pgsql-sql by date:

Previous
From: "Graham Vickrage"
Date:
Subject: SQL For smarties
Next
From: "David Huselid"
Date:
Subject: Re: create index on function - why?