Changing the ordering of joins in a view
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?
The same question
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
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
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
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
Replies have been locked on this page!