SELECT LIKE 'xxx%' doesn't use index scan

From: dhliu <dh(dot)liu(at)msa(dot)hinet(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: SELECT LIKE 'xxx%' doesn't use index scan
Date: 2007-12-19 03:38:28
Message-ID: 47689234.8010507@msa.hinet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

db =# explain SELECT seq FROM tab WHERE str like 'edt%';
QUERY PLAN
-----------------------------------------------------------
Seq Scan on tab (cost=0.00..6465.55 rows=1 width=4)
Filter: (str ~~ 'edt%'::text)
(2 rows)

db=# explain SELECT seq FROM tab WHERE str = 'edta';
QUERY PLAN
------------------------------------------------------------------------------
Index Scan using tab_pkey on tab (cost=0.00..8.30 rows=1 width=4)
Index Cond: (str = 'edta'::text)
(2 rows)

PostgreSQL 8.2.5 on i586-mandriva-linux-gnu, compiled by GCC
i586-mandriva-linux-gnu-gcc (GCC) 4.2.2 20070909 (prerelease)
(4.2.2-0.RC.1mdv2008.0)

Thank you.

Edward Liu

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-12-19 05:29:58 Re: ltree installation error
Previous Message Iuri Sampaio 2007-12-19 03:28:47 ltree installation error