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:



Discussion

No Comment Found