Hi,

I am getting the below warining when i join a the tablea with tableb(this table doesnt have any keys or constraints) which inturn is leading to the below warning. I am running the query from datastage which doesnt allow to run the query when it generates the warnings. so how can i proceed now?

SQL0437W Performance of this complex query may be sub-optimal. Reason code:

Maybe there are invalid statistics?
(BTW, what was the Reason code?)