Re: create index on function - why?

From: Luis Sousa <llsousa(at)ualg(dot)pt>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: Wei Weng <wweng(at)kencast(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: create index on function - why?
Date: 2002-02-15 17:22:51
Message-ID: 3C6D43EB.5040201@ualg.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message david blood 2002-02-15 17:27:15 current connections and queries
Previous Message Graham Vickrage 2002-02-15 17:14:28 SQL For smarties