Postgres Pro
Downloads
Home   >   mailing lists

index usage in not like - Mailing list pgsql-performance

From AI Rumman
Subject index usage in not like
Date
Msg-id 2a7905441002180355w6dc89a87y8643c0a7f881072a@mail.gmail.com
Whole thread Raw
Responses Re: index usage in not like  (Thom Brown <thombrown@gmail.com>)
List pgsql-performance
Tree view
"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.
 

pgsql-performance by date:

Previous
From: Michael Clemmons
Date:
Subject: Michael Clemmons wants to stay in touch on LinkedIn
Next
From: Thom Brown
Date:
Subject: Re: index usage in not like