Re: [ADMIN] what is the cause that scan type is showing as 'seq scan' after

2004-01-05 Thread Joseph Lemm
ially about how to set these params and what the defaults are (the official docs don't say much)? Thanks. --- Gaetano Mendola <[EMAIL PROTECTED]> wrote: > Joseph Lemm wrote: > > IN RELATION TO THIS POST: > > > > On Sun, Jan 26, 2003 at 06:31:50PM +0530, shreedhar wr

Re: [ADMIN] what is the cause that scan type is showing as 'seq scan' after indexing

2004-01-03 Thread Joseph Lemm
IN RELATION TO THIS POST: On Sun, Jan 26, 2003 at 06:31:50PM +0530, shreedhar wrote: > Hi All, > > Before indexing query plan was showing cost as 40.00, after indexing query > plan again showing as 'seq scan' and cost as 3060.55. > The field which i indexed is primary key to this table. > May i k