NSSQL Tips #4

The following statements are forbidden because they result in poor maintainability.

·         SELECT * FROM <table>
Using SELECT * also may result in a less efficient access-padh. Using VSBB or Index-Only access may not be chosen.

Specify all needed columns:
SELECT (col1, col2)

·         INSERT INTO <table> VALUES (valcol1, valcol2)

Specify all columns. (Columns with default-values may be left out).

INSERT INTO <table> (col1, col2) VALUES (valcol1, valcol2)

The following statement is forbidden because it often gives unexpected results.

·         CONTROL TABLE <tabel>
Rather use a control-statement with the needed option and the correct (default) value.