"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.
"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.