Re: what its better seqscan or indexscan

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Mario Alberto Soto Cordones <mario_soto(at)compuall(dot)cl>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: what its better seqscan or indexscan
Date: 2003-03-24 18:59:26
Message-ID: 20030324105832.W25958-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Mon, 24 Mar 2003, Mario Alberto Soto Cordones wrote:

> what its a better use the seqscan or indexscan

Neither in general, it depends on the particular query and the number of
rows in a table and number of rows you're expecting to return.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2003-03-24 18:59:28 Re: what its better seqscan or indexscan
Previous Message Robert Treat 2003-03-24 18:57:06 Re: 7.3.2 strange behavior (long)