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. > Is there any other way to achieve this?
Yes, just use the other table right in your query. There is no need to add wrappers. select * from schema1.table join schema2.table on ... depesz
