Forum Discussion
Refresh starts over
Hi all, I have a query (or a few) that was getting progressively slower and now often fails due to timing out. I noticed in the Desktop application that the refresh of certain of the bigger q...
Before the merge: rename your IdeaID column in the second table to Idea.2. Then replace Table.NestedJoin with Table.Join and remove the new column name parameter (in quotes before JoinKind.Outer.
This will significantly improve the performance. Essentially, we are just using Table.Join instead of Table.NestedJoin.
--Nate
The reason is that when you expand the nested tables, you are basically running the query for each row in the table.
--Nate