Thread: what its better seqscan or indexscan
Hi.. what it´s a better use the seqscan or indexscan thank Mario
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.
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