Poor Performance query - too many rows examined in customer portal
Poor performance query - Too many rows examined while searching the below query in Customer Portal though it has less than 50 records, whereas the same query criteria retrieve the results in Analytics. The columns ( First Name, Last name) used in the search query are already indexed.
Also when the same query is searched in Connect Object Explorer, neither error nor results was displayed.
select * from incident Where CreatedTime >= '2018-08-01' AND CreatedTime <= '2018-08-28' AND PrimaryContact.ParentContact.Name.First Like '%ab%' AND PrimaryContact.ParentContact.Name.Last Like '%fa%'