Forum Discussion
Optimizing Calculated Column for approx 2million Rows of Data
I have the following columns: refCallDetail[ANI_DIALNUM], refCallDetail[contact_name], refCallDetail[Contact Type], refCallDetail[start_datetime], refCallDetail[end_datetime] each with pre...
HI gra_wang
It looks pretty well optimised, but can you please clarify what you are trying to achieve?
It looks like, for every row in the table, it wants to count the number of other Contacts that have a row from the same table between the start/end dates