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