Reading Time: 4 minutes
Netezza uses the cost based optimizer to determine best methods determine redistribution, scan, join, join orders. Netezza query optimizer relies on the statistics from catalog to come up with an optimal query execution plan. So it is imperative that the statics need to be kept current without which the execution plan generated by the optimizer may be sub-optimal resulting… Continue reading Netezza Generate Statistics