Re: Suggestion to improve query performance of data validation in proc.

Поиск

Список

Период

Сортировка

От	David G. Johnston
Тема	Re: Suggestion to improve query performance of data validation in proc.
Дата	22 мая 2020 г. 11:09:40
Msg-id	CAKFQuwbcjxWdSQSThOy7Ofo2+8+nK5fGHMoBuciZxjS6RB9CVQ@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Suggestion to improve query performance of data validation in proc. (postgann2020 s <postgann2020@gmail.com>)
Ответы	Re: Suggestion to improve query performance of data validation in proc. (Michael Lewis <mlewis@entrata.com>)
Список	pgsql-general

On Friday, May 22, 2020, postgann2020 s <postgann2020@gmail.com> wrote:

We are looking for a better query than "SELECT 1 FROM schema.table_name WHERE column1=structure_id1" this query for data validation.

There is no more simple a query that involve records on a single,table.

Please suggest is there any other ways to validate this kind of queries which will improve the overall performance.

Abandon procedural logic and embrace the declarative set oriented nature of SQL.

David J.

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

От: postgann2020 s
Дата: 22 мая 2020 г., 10:44:27
Сообщение: Re: Suggestion to improve query performance of data validation in proc.

От: Tim Kane
Дата: 22 мая 2020 г., 11:19:57
Сообщение: btree_gist extension - gbt_cash_union return type