Forum Discussion

gra_wang's avatar
gra_wang
Icon for Helper I rankHelper I
8 years ago

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...
Need Help
Tips and Tricks
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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