There are primarily three reasons why SELECT* is never given preference in an embedded SQL program. These are: –
-In case if there is an alteration in the structure of the table, then the program has to undergo a modification process.
-All columns will be retrieved by the program including those columns , which might not be used.
-In case if the user wishes to scan the index, then that will not be possible.