Did a single synthetic key affect the whole data model

[shantanu73]

Hello Forums/Friends,

Did a single synthetic key affect the whole data model? Y/N. Can Explain

Thanks in Advance

Shantanu

[alexandros17]

My experience shows that a single syntetic key can affect the performance of the document:

1) the size of the document increase in proportion on fields involved in sysntetic key and numbers of syntetic keys

2) the loading is slow

3) sometimes data is not associated as you expect

[#3]

hi

yes,

because response time increase then

performance decreases.

when synthetic key made,

then two table are not directly associte or linked ,

the linking established between two table via synthetic table.

so linking between two table is achieve via synthetic table