Every entity has attribute ‘id’. Optional it has ‘ createddate’, ‘owner’, ‘changeddate’ and ‘changedby’. Which fo these fields of Mendix tables are indexed by default? Only ‘id’? *Editted after getting the answer*: Indeed, I see, the id-field and both ‘user’-associations. Not the dates. And Postgres always creates an index for a primary key.
Tim v Steenbergen
You can check it yourself when you use PGAdmin click on the entity and then the tab dependents. It is only id, owner and changedby if all marks are checked.