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

Filtering on phone field, ph_home_raw, exceeds query size limitation

Accepted answer
15
Views
3
Comments
edited Jun 19, 2019 1:52PM in Reporting & Analytics for B2C Service 3 comments

Summary

Why does filtering on ph_home_raw analyze so many rows compared to ph_home

Content

When I filter on ph_home, the Analyzer tells me that the estimated number of analyzed rows is 6. When I filter on ph_home_raw field, the estimated number of analyzed rows is over 2.4million. What is the reason for this huge increase, besides the field not being indexed?

The main problem is that we are unable to perform contact searches on this ph_home_raw field because this query is over the threshold for the Operational Database. On the other hand, filtering on the indexed phone field,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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