Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group