Hi Team,
Thanks for your support.
Could you please suggest on below query.
We have multiple long procs that are having 100s of data validations and currently we have written as below.
***********
if (SELECT 1 FROM SCHEMA.TABLE WHERE column=data AND column=data) then
statements
etc..
***********
Are there any other ways to validate the data, which will help us to improve the performance of the query?.
Thanks for your support.
Regards,
PostgAnn.