select like and indexes

From: "William N(dot) Zanatta" <william(at)veritel(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: select like and indexes
Date: 2003-01-20 18:12:00
Message-ID: 3E2C3BF0.4010804@veritel.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I'm quite new to postgresql. I need some help to understand some of
'how it works'.

I have a table with aprox. 1 million tuples (row == tuple ??) and
I've created an index on a column 'ip' in my table.

Well the question is: when I do,

explain analyze select * from tbl_xxxx where ip like '200%';

why PG doesn't use Index Scan method? why does it uses sequential
scan in place?

Thank you,

william

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jerome 2003-01-20 18:12:40 URGENT: dropping constraints and references from a table
Previous Message Andrew Sullivan 2003-01-20 18:05:21 Re: Is there a good way to make the database server send e-mail?