You can improve session performance by sorting source data by primary key or a specified number of ports. Configure the Order By Ports property in the source definition. When the Designer generates ABAP using nested loop joins, it determines the number of columns for each source.

The Designer generates an Order By statement in the ABAP program when you specify a positive number of ports. Order by support differs for transparent tables and pool and cluster tables.