+2Hi all ,
One of our PS customer is wondering what is the best option ?
Using composite PK with 2 to 15 columns or using surrogate keys implying an extra additional join for each query (since the relation between the PK and the surrogate key will be defined in an extra table) ?
Regards
Bernard
+1This is independent of the DBMS - and very true for Vertica, too:
Add a surrogate key to your table - and use the joins you mention to feed it, not to query it.
+2Hi Marco , thanks for the answer , but could you elaborate a bit more ?
I am not too sure to understand what you mean with "use the joins to feed it, not to query it."
Regards
Bernard
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
