N1ql query Optimization query

select email from data
where type_=‘Info’
and Any v In [LOWER(surname),LOWER(name)] SATISFIES v like ‘%ram%’ END
offset 0 limit 10;

Its taking time after index creation also.
please help me how i can search name in both column with optimized way.