Suggestion to improve query performance of data validation in proc.

Поиск
Список
Период
Сортировка
От postgann2020 s
Тема Suggestion to improve query performance of data validation in proc.
Дата
Msg-id CANynezPm5t35FEiCV7zukXd+N_u4LPDVU0E7fzn0hKZ6CeOoQg@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Raj kumar
Дата:
Сообщение: Lag clarification with Sync Replication
Следующее
От: devchef2020 d
Дата:
Сообщение: Request to help on Query improvement suggestion.