Received: from smtp.ualg.pt (smtp.ualg.pt [193.136.224.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1FHMrE20682 for ; Fri, 15 Feb 2002 12:23:09 -0500 (EST) (envelope-from llsousa@ualg.pt) Received: from localhost (smtp.ualg.pt [127.0.0.1]) by smtp.ualg.pt (Postfix) with ESMTP id 74AE04BB98; Fri, 15 Feb 2002 17:22:52 +0000 (WET) Received: from ualg.pt (corisco.uceh.ualg.pt [10.10.20.126]) by smtp.ualg.pt (Postfix) with ESMTP id A5F084BB83; Fri, 15 Feb 2002 17:22:51 +0000 (WET) Message-ID: <3C6D43EB.5040201@ualg.pt> Date: Fri, 15 Feb 2002 17:22:51 +0000 From: Luis Sousa User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.5) Gecko/20011023 X-Accept-Language: en MIME-Version: 1.0 To: Bruno Wolff III Cc: Wei Weng , pgsql-sql@postgresql.org Subject: Re: create index on function - why? References: <3C6D3684.9040101@kencast.com> <20020215170128.GB2025@wolff.to> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS snapshot-20010714 X-Archive-Number: 200202/182 X-Sequence-Number: 6608 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 > >