There is a wrong perception amoung someDBAs that the if statement in procedures
would cause a recompile of the procedures at the execution time. However, it is
been proved that if a procedure contains if statements, all codes are getting compiled
at the first compilation stored in the......