Changing the ordering of joins in a view
I have joined a few tables in the View: Entity Relationships screen. The joins are, however, in a different order and produce an SQL statement where JOIN clauses are ordered slightly differently than intended. This then leads to worse performance of the query. Is there a way to change the order of Joins in a view?