Skip to Content
0
Former Member
May 14, 2010 at 06:56 AM

Why does BW use surrogate keys ?

211 Views

Hi,

can anyone answer me in 1 sentence:

Why dos BW uses surrogate / artifical keys ?

Its not faster while querying - line items are faster & y need query more tables.

Its not faster while loading - surrogate keys need to be looked up and build up.

ThanXs

Martin