Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Greetings,
I have a merge query that does a join to a list with 5 user fields. When I expand those user fields to find the first name and last name the query slows way down. Is this because the user fields are basically lookups? Is this normal?
I tried to optimize the query and reduce the number of fields that I return to the bare minimum. It appears when I hit the Step that extracts the names, the query slows down.
Yes this is normal, merges are fairly expensive and can get (very) slow.
Thanks, but when I take the people fields out of the query, it is under a minute to return.