G-3150 – Try to use identity columns for surrogate keys.

An identity column is a surrogate key by design – there is no reason why we should not take advantage of this natural implementation when the keys are generated on database level. Using identity column (and therefore assigning sequences as default values on columns) has a huge performance advantage over a trigger solution.

Tags: SQL.

Quality area: Reliability. Severity: Critical. Fixing time: Other.