Re: Substitute for synonym in Oracle after migration to postgres

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Substitute for synonym in Oracle after migration to postgres
Дата
Msg-id 5fbb9bbf869f1880928f377dbd7e7fd4d167e31b.camel@cybertec.at
обсуждение исходный текст
Ответ на Substitute for synonym in Oracle after migration to postgres  (aditya desai <admad123@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
On Tue, 2021-04-06 at 13:22 +0530, aditya desai wrote:
> We have to access data from one schema to another. We have created
>  a view for this but performance is not good.

The performance of a view that is just a simple SELECT to a table
in a different schema will be just as good as using that table
directly.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

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

Предыдущее
От: aditya desai
Дата:
Сообщение: Substitute for synonym in Oracle after migration to postgres
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Substitute for synonym in Oracle after migration to postgres