Forum Discussion
Query folding and column removal
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 🙂
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
2 Replies
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