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
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.
Is there any other way to achieve this?
Regards,
Aditya.
