Issues with Indexed Views in SQL Server 2008r2 on a table with persisted columns and with low DML activity
I am issues with using indexed views. I have a product catalog and a stored proc reads the data in the rows according to various filters on the data. At the same time, the data needs to remain in XML ...
What exactly mean the terms monoblock / multiblock queries in data warehouses when talking about materialized views? Does a monoblock query just use one data source (a normal table) while a multiblock ...
In our product we have a main application with an oracle 11g DB and an optional module with another DB. We want the two to communicate through a dblink and I was told to put some code for the ...
Apologies if it's a simple question, DBA is not my main area of expertise! I have a materialized view that's fast refreshable, joining two tables. When I try to drop either the MV itself or logs ...