Re: Why index scan doesn't work ??? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Why index scan doesn't work ???
Date
Msg-id 200208231203.48408.dev@archonet.com
Whole thread Raw
In response to Why index scan doesn't work ???  (Tourtounis Sotiris <tourtoun@csd.uoc.gr>)
List pgsql-general
On Friday 23 Aug 2002 11:46 am, Tourtounis Sotiris wrote:
> Hello i have a question baout the functionality of index.
>
> select Y.att0 from class X, class Y where ((X.att0 = %d) and (X.att1 <=
> Y.att0) and (Y.att0 <= X.att0))

Run EXPLAIN ANALYSE SELECT .... and if the output doesn't make any sense post
it back here, then we'll be able to see.

See Ch11 of the user's guide for an explanation of EXPLAIN.

- Richard Huxton

pgsql-general by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: trigger fired on changes in specific column
Next
From: Tom Lane
Date:
Subject: Re: Two servers on one machine