Sort cost during sort-merge joins depends on:
The size of the worktables, which depends on the number of columns and rows selected
The setting for the number of sort buffers configuration parameter, which determines how many pages of the cache can be used
These variables affect the number of merge runs required to sort the worktable.