Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Simple question, which I would like to ask: Does the command remove other columns break query folding? When I tried to use "remove other columns", the field "View Native Query" went blank. A long time ago I however saw a video from Guy in Cube, where they were talking that it always doesn't mean that the query folding is broken. I can't remember how to test it. Could anyone simply answer? thanks 🙂
Solved! Go to Solution.
It does not usually break folding, unless it's a key column.
--Nate
So, I went to the video from Guy in a Cube and found out that at the end of the video they perform diagnosis, where, as one of the steps, they do "remove other columns" and apparently the folding works. https://www.youtube.com/watch?v=QEFze-LdLqo&ab_channel=GuyinaCube
It does not usually break folding, unless it's a key column.
--Nate
So, I went to the video from Guy in a Cube and found out that at the end of the video they perform diagnosis, where, as one of the steps, they do "remove other columns" and apparently the folding works. https://www.youtube.com/watch?v=QEFze-LdLqo&ab_channel=GuyinaCube