Why SELECT * is not preferred in embedded SQL programs?5
1232 5b5cc7d9e4d2b41977751577
Q: Why SELECT * is not preferred in embedded SQL programs?
- Show Answer
- Workspace
- Discuss
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.