Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if i am not removing synthtickey what will happen ?
pls advce
Hi Satya,
If your model has been built correctly, and indeed all fields in the synthetic table are the same (key-foreign key fields) then nothing wrong will happen.
If you did not expect synthetic keys to happen, then they are likely the result of some issue while modelling, where although two fields are named alike, they don't really contain the same information (e.g: field ID in Customer table and field ID in Invoice table refer to different entities). In this case, you will see erroneous results and you should be fixing that modelling issue.
Miguel
Also, those synthetic keys are using extra memory of your RAM, so rather than making synthetic tables concatenate the desired columns to make 1 key.
Hi Ankita,
Not always, as shown in the blog below. If synthetic keys are looked for as a way to save development time, they will not use more memory or CPU that any other key.
However, if we recommend not to use synthetic keys it is not because performance, but mainly because they are produced as a result of a bad data modelling that is the issue.
Miguel