Multiple choice technology performance

Always fetch all the columns data from the table

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Always fetching all columns is bad practice. It increases network traffic, memory usage, and I/O. Use SELECT with specific columns needed for the query. This is called 'projection' and is fundamental to SQL performance optimization.