Changing the ordering of joins in a view

Jan Raszyk shared this question 2 years ago
Answered

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?

Best Answer
photo

Hello,


at this time you can't reorder joins, unless you use freehand SQL to achieve the desired order.


you can view the SQL for the current view in the editing mode, then copy/modify this in the freehand SQL section.


I hope this helps,

Best regards,

Pete

Comments (1)

photo
1

Hello,


at this time you can't reorder joins, unless you use freehand SQL to achieve the desired order.


you can view the SQL for the current view in the editing mode, then copy/modify this in the freehand SQL section.


I hope this helps,

Best regards,

Pete