Coalesce in Query dramatically slows Elasticube build.

I have a coalesce in one my joins in my query and it is dramatically slowing the elasticube build. Anyone else experience? If so, do you have a better solution?

Zach Williams

Posted 1 year ago·Last reply 1 year ago

5 comments

Zach Williams

OP1 year ago

Hi DRay I have removed the coalesce for now. The query is fine using either of the ID fields independently but the coalesce slows it for some reason.

DRay

·1 year ago

Interesting. If you like, I can get the ball rolling on connecting you with a technical resource on our team to look into this with you. Would you like me to do that?

DRay

·1 year ago

Hi zach_myt,

I just wanted to follow up with you to see if you still need help with this.

DRay

·1 year ago

Hello zach_myt,

Thank you for reaching out. I see your question hasn't gotten a response yet, so I'm asking internally to try and get you an answer.