what its better seqscan or indexscan

Поиск
Список
Период
Сортировка
Искать

what its better seqscan or indexscan

От:
"Mario Alberto Soto Cordones" <mario_soto@compuall.cl>
Дата:
Hi..

what it´s a better use the seqscan or indexscan

thank

Mario

Re: what its better seqscan or indexscan

От:
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Дата:

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.

Re: what its better seqscan or indexscan

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:

See the FAQ entry on index usage.

---------------------------------------------------------------------------

Mario Alberto Soto Cordones wrote:
> Hi..
> 
> what it?s a better use the seqscan or indexscan
> 
> thank
> 
> Mario
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

FAQ