320 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