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.