Join Examsbook
474 0

Q: Why SELECT * is not preferred in embedded SQL programs?

  • Show AnswerHide Answer
  • Workspace

Answer :
Explanation :

- If the table structure is changed ( a field is added ), the program will have to be modified. - Program might retrieve the columns which it might not use, leading on I/O over head. - The chance of an index only scan is lost.

Are you sure

  Report Error

Please Enter Message
Error Reported Successfully
google play

The Most Comprehensive Exam Preparation Platform

Get the Examsbook Prep App Today