Suggestion to improve query performance of data validation in proc.

[postgann2020 s <postgann2020@xxxxxxxxx>]

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.