1.

Is there any specific reason why SELECT is not preferred in embedded SQL programs?

Answer»

The SELECT statement is not preferred in EMBEDDED SQL programs for 3 reasons:

  • If there is a CHANGE in the structure of the table by addition or deletion of a field, the PROGRAM gets modified and using the SELECT statement MIGHT retrieve those columns that the user may not even USE.
  • The use of SELECT in the embedded SQL programs can lead t the input-output overhead and,
  • The chances of an index-only scan are eliminated by the use of SELECT in embedded SQL programs. 


Discussion

No Comment Found

Related InterviewSolutions