Netezza Balanced optimizer adds order by clause
Posted: Thu Mar 21, 2013 12:20 am
Hi all,
when using the balanced optimizer for Netezza, the join stages being pushed back to the source database, are combined in a single query
as planned. For some reason there is an order by clause added on the join key columns.
This order by slows down query performance big time, so question is how to make balanced optimizer loose the urge to create the order by clause...
Not keen on changing the optimized jobs after they are being created, for obvious reasons...
thanks,
William
when using the balanced optimizer for Netezza, the join stages being pushed back to the source database, are combined in a single query
as planned. For some reason there is an order by clause added on the join key columns.
This order by slows down query performance big time, so question is how to make balanced optimizer loose the urge to create the order by clause...
Not keen on changing the optimized jobs after they are being created, for obvious reasons...
thanks,
William