Query folding and column removal

[zenisekd]

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 🙂

[watkinnc · Accepted solution]

It does not usually break folding, unless it's a key column.

--Nate

[watkinnc · Accepted solution]

It does not usually break folding, unless it's a key column.

--Nate

[zenisekd · Accepted solution]

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