Data relations and indexing

Data Service
1

When defining a table column as “Data Object Relationship”, I cannot tag this column as an indexed column, only as “unique”.

  • Are those columns columns automatically indexed?
  • Is it possible at all to index those columns?

Regards,

2

Hello,

Indexing applies only to “data carrying” columns. A relationship column is a technically a foreign key constraint in the database and thus cannot be indexed.

Regards,
Mark

3

Ok. Then I have to add an extra column for indexing
Thanks