"stormbyte@gmail.com" <stormbyte@gmail.com> wrote:=0A=0A> [ Seq Scan is use=
d on empty relation, rather than Index Scan ]=0A=0A> This is not the expect=
ed result.=A0 [ ... ] it is still using=0A> sequential scan rather than wha=
t would be expected: Index Scan=0A=0AThis is not a bug.=0A=0AIf statistics =
indicate that all rows can be accessed with one page=0Aaccess (to the heap)=
why should it use an index?=0A=0A--=0AKevin Grittner=0AEDB: http://www.ent=
erprisedb.com=0AThe Enterprise PostgreSQL Company