Bring Back Optimization for Reading Subcolumns in Compact Parts

Bring back optimization for reading subcolumns of single column in compact parts from #57631. It was deleted accidentally. #72285 (Pavel Kruglov).