$SynTables

[jurciello]

Hi, everyone.

In case when we have got a synthtable, we are going to avoid it, creating link table (simply own-created table) in the load script. For example Table1(fields: a,b,c,d), Table2(fields: a,b,c,x,y,z). After that Table1(fields: d),linktable(a&b&c,a,b,c), Table2(fields:x,y,z). But, in some more complex cases of Data Models QV takes off some fields from linktable and put them into $SyntTable. Can anyone explain me purpose of this action?

Best regards ,

YuCH

[its_anandrjs]

It is to maintain the unique key combination between the tables that is the purpose.

[jurciello]

So, when Developer performs link via linktable(correct from his point of view) but QV appologize that such link doesn`t perform unique key combination. That`s why QV creates it`s own $Synth ?

[hic · Accepted solution]

The QIX engine will create a synthetic table as soon as there is more than one key between tables. So it is basically the engine's way of creating an internal link table. See more on Synthetic Keys

HIC

[jurciello]

Thanks to all for answers