Re: [SQL] Table scan instead of index scan

2001-07-24 Thread Stephan Szabo
On Tue, 24 Jul 2001, [ISO-8859-1] Mário Sérgio G Antunes wrote: > I use PostgreSQL 7.1.2.4 in two servers under RedHat 7.0. > Our database has a table like that: > create table tb_client > ( >id_client varchar(32), >client_name varchar(40), >bdate date, > ... > ); > > create index

[SQL] Table scan instead of index scan

2001-07-24 Thread Mário Sérgio G Antunes
Hi, I am sure PostgreSQL is a very powerful product! I use PostgreSQL 7.1.2.4 in two servers under RedHat 7.0. Our database has a table like that: create table tb_client ( id_client varchar(32), client_name varchar(40), bdate date, ... ); create index xiftb_client on tb_client(id_cl