Are there differences in performance in relations, when you use a global at the left side or a calculation: (for example) return 1 ?
Are there advantages or disadvantages to do it one way or the other?
A global based relation is normally faster becouse it not a real database join, it is becomes a sql “where” expression (=). A normal relation and a global one a different things for different purposes.