In what Scenarios Synthetic Keys are better then trying to remove them?

[retko1985]

Are there any of those scenarios or should I always try to remove them?

Thank you.

[swuehl]

Have you already had a look at

Synthetic Keys

[tomasz_tru · Accepted solution]

When you have a lot of rows and a key created from multiple columns, loading time could be much faster for synthetic key than for field concatenation.

Tomasz