When you have a main subject with a detail page, I noticed the GUI executes the following query on each row selection in preparation for loading the detail (GUI & Indicium version 2026.1.15).
SELECT t1.[REF-COL1], t1.[REF-COL2]
FROM [MAIN-SUBJECT] t1
WHERE t1.[PK1] = @p0 AND t1.[PK2] = @p1
When you have 4 details, it executes 4 of these queries, even when the reference columns are the same.
When this is executed on a table, the cost of this query is insignificant since it can always use the primary key index to retrieve exactly one record. But when the main subject is a view, this could be a different story depending on the view code.
Could this behaviour be improved so it doesn’t have to access the main subject so many times? It seems that it should at least be possible to gather all reference columns for all references with one query at once. But it would be even better if it could use the data from when the main subject was loaded itself.