Re: Why sequential scan with index present?

From: "Michael Labhard" <ince(at)pacifier(dot)com>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: Why sequential scan with index present?
Date: 2002-08-31 16:29:56
Message-ID: akqqr5$ohl$1@main.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

Found answer somewhere on PostgreSQL web site: optimizer uses sequential
scan anyway if the number of records are small.

-- Michael

In response to

Browse pgsql-cygwin by date

  From Date Subject
Next Message Michael Labhard 2002-08-31 18:48:19 PostgreSQL unsuitable for large datasets?
Previous Message Jason Tishler 2002-08-30 19:43:06 Re: PG on Win2K