Re: View not using index

From: Russell Smith <mr-russ(at)pws(dot)com(dot)au>
To: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: View not using index
Date: 2005-06-13 07:05:35
Message-ID: 200506131705.35852.mr-russ@pws.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, 13 Jun 2005 04:54 pm, Yves Vindevogel wrote:
> Still, when I use explain, pg says it will first sort my tables instead
> of using my index
> How is that possible ?

Can we see the output of the explain analyze?
The definition of the view?

Regards

Russell Smith

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Yves Vindevogel 2005-06-13 07:18:50 Re: View not using index
Previous Message Yves Vindevogel 2005-06-13 06:54:21 View not using index