index usage in not like
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
:
pgsql-performance@xxxxxxxxxxxxxx
Subject
: index usage in not like
From
: AI Rumman <
rummandba@xxxxxxxxx
>
Date
: Thu, 18 Feb 2010 17:55:52 +0600
"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.
Follow-Ups
:
Re: index usage in not like
From:
Thom Brown
Prev by Date:
Michael Clemmons wants to stay in touch on LinkedIn
Next by Date:
Re: index usage in not like
Previous by thread:
Michael Clemmons wants to stay in touch on LinkedIn
Next by thread:
Re: index usage in not like
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
