Join ExamsbookAnswer :
Why SELECT * is not preferred in embedded SQL programs?5
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.
Similar Questions
Since Nithya and Suganya exchange places, so Rita’s new position is the same as Monika’s earlier position. This position is 17th from the right and 10th from the left. Therefore Number of girls in the row = (16 + 1 + 9) = 26.