Home > mailing lists

Re: what its better seqscan or indexscan - Mailing list pgsql-admin

From	Stephan Szabo
Subject	Re: what its better seqscan or indexscan
Date	March 24, 2003 16:59:29
Msg-id	20030324105832.W25958-100000@megazone23.bigpanda.com Whole thread Raw
In response to	what its better seqscan or indexscan ("Mario Alberto Soto Cordones" <mario_soto@compuall.cl>)
List	pgsql-admin

Tree view

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

> what it�s 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.

pgsql-admin by date:

From: Robert Treat
Date: 24 March 2003, 16:57:43
Subject: Re: 7.3.2 strange behavior (long)

From: Bruce Momjian
Date: 24 March 2003, 17:00:01
Subject: Re: what its better seqscan or indexscan

Re: what its better seqscan or indexscan - Mailing list pgsql-admin

Previous

Next