Poor Performance query - too many rows examined in customer portal

Content

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.

 

Version

Customer Portal

Code Snippet

             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%'