Thanks will check.
On Tue, Apr 6, 2021 at 4:11 PM hubert depesz lubaczewski
wrote:
> On Tue, Apr 06, 2021 at 01:22:31PM +0530, aditya desai wrote:
> > Hi,
> > We have to access data from one schema to another. We have created a
> view for this but performance is not good. We tried
> > materializ
On Tue, Apr 06, 2021 at 01:22:31PM +0530, aditya desai wrote:
> Hi,
> We have to access data from one schema to another. We have created a view for
> this but performance is not good. We tried
> materialized views as well but Refresh MV is creating problem as it puts and
> access exclusive locks.
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 tab
