問題文
A wide table is queried for a few columns out of two hundred. Which storage choice reduces the bytes read?
選択肢
- The columnar arrangement lets the scan fetch picked columns from each file, and the row-oriented text layout forces the scan to read whole lines during every pass.
- The columnar arrangement lets the scan fetch complete stripes from each file, and the row-oriented text layout forces the scan to read whole lines during every pass.
- The columnar arrangement lets the scan fetch picked columns from each file, and the row-oriented text layout forces the scan to read grouped keys during every pass.
- The columnar arrangement lets the scan fetch complete stripes from each file, and the row-oriented text layout forces the scan to read grouped keys during every pass.