Balanced Optimizer & Operations Console

nvalia · Post by **nvalia** » Tue Oct 07, 2014 3:54 am

Hi All,

When we use Balanced Optimizer for SQL Push Down into the Database (Netezza in our case) will we still be able to get the Operational Metadata information from the Operations Console as we would expect to get for the Original (Pre BO) job?

e.g. I mean information like rows per link

Thanks,
NV

priyadarshikunal · Post by **priyadarshikunal** » Tue Oct 07, 2014 4:09 am

Did you try balance optimization. I do not have access to 8.7+ environment but you should get the Operations details of the job after balance optimizer has been used. It may or may not be same as pre-BO but you should get the details of the new job.

kwwilliams · Post by **kwwilliams** » Tue Oct 07, 2014 7:38 am

Rows per link in a BO job that completely pushes the work down to the database would be pretty meaningless. Look at the example you are giving for performance tuning in another post:

Code: Select all

Row Generator -->  Neteeza

There is 1 link and the number of rows across the link is 1. Depending upon the database stage that is the target, there may be a number of rows deleted/updated/inserted in the job log.