"Not like" operation does not use index.
select * from vtiger_contactscf where lower(cf_1253) not likelower('Former%')
I created index on lower(cf_1253).
How can I ensure index usage in not like operation?Anyone please help.