We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Poor Performance query - too many rows examined  in customer portal

Accepted answer
14
Views
1
Comments
edited Aug 28, 2018 7:34AM in Customer Portal 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!