One of my query is failing and giving Apex CPU time limit exceeded
The field we are using in custom formula in Contact created to retrieve the domain from the standard Email field to possibly reduce the run-time.
My questions are -
1. Can we benefit from indexing the custom field field to solve this problem?
2. Can a LIKE function increase the query run-time?
3. Does the number of fields in the SELECT affect the CPU time ? say if I have one field (Id) vs. dynamic number of fields that can reach even 20 fields
4. Is there any other suggestions for optimizing the query and reduce the run-time?