Intermediate Big Data & Data Engineering
Q72 / 100

Why is it generally recommended to avoid SELECT * in large-scale analytical queries?

Correct! Well done.

Incorrect.

The correct answer is A) It forces reading all columns even from columnar storage, increasing I/O and query cost unnecessarily

A

Correct Answer

It forces reading all columns even from columnar storage, increasing I/O and query cost unnecessarily

Explanation

In columnar formats, selecting only needed columns lets the engine skip reading irrelevant column data, reducing I/O, cost, and query time significantly.

Progress
72/100