Why Select * Is Not Preferred In Embedded Sql Programs?

1.	Why Select * Is Not Preferred In Embedded Sql Programs?
Answer» For THREE reasons: 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. For three reasons:

Answer»

For THREE reasons:

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.

For three reasons:

Discussion