Re: Why index scan doesn't work ???

From: Richard Huxton <dev(at)archonet(dot)com>
To: Tourtounis Sotiris <tourtoun(at)csd(dot)uoc(dot)gr>, pgsql-general(at)postgresql(dot)org
Subject: Re: Why index scan doesn't work ???
Date: 2002-08-23 11:03:48
Message-ID: 200208231203.48408.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Bjorklund 2002-08-23 11:03:53 Re: trigger fired on changes in specific column
Previous Message Tourtounis Sotiris 2002-08-23 10:46:40 Why index scan doesn't work ???