I have couple questions after going thru the link.
After reading the above link I had a feeling the REOPT(ONCE) would improve the performance of the SQL.Since, I have normally same set of columns which I update.Am I right in thinking so?
2) Though I have normally same set of columns , But i have different data to these fields for update.Then will the REOPT(ONCE) works fine as static sql.
3)Do I have to make any special changes in the program after giving this above option.
4)If I have to change my bind otpion then do I have change the option "NOREPT VARS" with once option,In the above statement.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum