Comparing the load times for the standard Table.Join function (using the Dynamic algorithm), the SortMerge algorithm (requires both tables are sorted on their keys) and LeftIndex (requires that the right table can be streamed e.g. a database)
You unfortunately can only add algorithms to Table.Join and not Table.NestedJoin, meaning PQ will automatically expand all columns of the right table. You may have to renamed the columns to avoid a clash (keys can often have the same name).
00:00 Standard algorithm, Dynamic
02:37 SortMerge and streaming
03:57 Compare load time
04:26 Summary of algorithms
