Join Product Skew[cont'd.]

• Dependence of virtual processor range partitioning on the number of samples is shown in the table 6 for the *10000 Join *100 join.

number of samples		    1800		   3600		   7200		  14400


execution time		       49.0		   47.8		  49.0		  49.7

• Observation : The performance is relatively stable independent of the number of samples. The general trend is that taking too few samples results in poor load balancing , While taking too many results in too much overhead due to sampling.