Re: "like" and index

From: Andrzej Zawadzki <zawadaa(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: "like" and index
Date: 2009-02-25 21:24:19
Message-ID: 49A5B703.7080700@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Daniel J. Summers wrote:
> Tony Liao wrote:
>> I try to explain analyze,but it doesn't work ,it use seq scan.
> Generally speaking, LIKE doesn't use indexes.
?! That's not true at all!!

--
Andrzej Zawadzki

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vladimir Rusinov 2009-02-25 22:08:47 Re: psqlrc file on RHEL5
Previous Message Harald Fuchs 2009-02-25 20:15:21 Re: "like" and index