When the data source it’s Synapse Analytics Server less pool and try a full load of a table, TX send to the server two queries, the first to obtain the MAX(incremental value) and the second to obtain the records with <= MAX(incremental value).
The cost it’s double. It would be better to send only the second query without the WHERE clausule.
