index usage in not like

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: index usage in not like
Date: 2010-02-18 11:55:52
Message-ID: 2a7905441002180355w6dc89a87y8643c0a7f881072a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Not like" operation does not use index.

select * from vtiger_contactscf where lower(cf_1253) not like
lower('Former%')

I created index on lower(cf_1253).

How can I ensure index usage in not like operation?
Anyone please help.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Thom Brown 2010-02-18 12:00:29 Re: index usage in not like
Previous Message Michael Clemmons 2010-02-18 01:04:12 Michael Clemmons wants to stay in touch on LinkedIn