[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] GIST index
From:       strk () refractions ! net
Date:       2006-02-18 14:46:59
Message-ID: 20060218144659.GE78371 () keybit ! net
[Download RAW message or body]

On Fri, Feb 17, 2006 at 02:51:22PM -0600, David Bitner wrote:
> Does the GIST index work for all of the operators, or just &&?

EXPLAIN should tell you. By disabling sequencial scan you can make
sure index is not skipped to to optimizer decision (custom statistics
are only used with &&).

--strk;

[prev in list] [next in list] [prev in thread] [next in thread]