Using materialized view in SQL
Hi,
We are on our UAT (testing environment). We have dataview which we are not able to run as there is a lof of data to check.
We are not able to deploy a package in the environment which contains the dataview.
We have to deploy a package whithout the dataview and then manually add the dataview in the environment.
Once we add the dataview, when we try to deploy it, it is taking so much time and we don't know if there is a timeout or not. We have integration based on the result of the dataview.
At this stage we are not able to obtain the result of the query.