Received: from abet.abet.com.br ([200.245.230.10]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6OCwQf89768 for ; Tue, 24 Jul 2001 08:58:26 -0400 (EDT) (envelope-from mariosergioa@msantunes.com.br) Received: from msantunes.com.br (IDENT:mariosergioa@[200.245.230.110]) by abet.abet.com.br (8.11.0/8.11.0) with ESMTP id f6OE1oT30386 for ; Tue, 24 Jul 2001 11:01:50 -0300 Message-ID: <3B5D7321.8060702@msantunes.com.br> Date: Tue, 24 Jul 2001 10:07:45 -0300 From: =?ISO-8859-1?Q?M=E1rio=20S=E9rgio?= G Antunes User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.2) Gecko/20010701 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Table scan instead of index scan Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Archive-Number: 200107/320 X-Sequence-Number: 4133 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_client); When I execute the following query: SELECT * FROM tb_cliente WHERE id_client LIKE '1234%'; One server executes index search and other full table scan. I don't know the reason. If you could help me I would appreciate a lot. Thanks, Mário Sérgio