Join stage
Posted: Thu Aug 18, 2011 6:27 am
Hi Guys,
In join stage, i am aware that the parallel engine will insert a tsort operator to do the sort operation, which in turn requires temp space in scratch disk to store the temporary files. If i dont do the sort operation by giving "dont sort environmental variable", temp space wont be required. How does the join based on the key happens here. It uses the temp space to do the join operation or it do in "on-fly" during database access. If yes, does join requires less temp space than sort. Please explain this scenario.
Thanks in advance.
In join stage, i am aware that the parallel engine will insert a tsort operator to do the sort operation, which in turn requires temp space in scratch disk to store the temporary files. If i dont do the sort operation by giving "dont sort environmental variable", temp space wont be required. How does the join based on the key happens here. It uses the temp space to do the join operation or it do in "on-fly" during database access. If yes, does join requires less temp space than sort. Please explain this scenario.
Thanks in advance.