Top "Materialized-views" questions

A materialized view is a database object that contains the results of a query.

How to refresh materialized view using trigger?

create or replace TRIGGER REFRESH_REST_VIEW AFTER INSERT OR UPDATE ON tbl_contract BEGIN execute DBMS_MVIEW.REFRESH('REST_…

sql oracle triggers oracle10g materialized-views
How to determine whether a table is used to store materialized view logs?

I have table with created on it materialized view log: create table T1(A number primary key); create materialized view …

sql oracle database-replication materialized-views
Is there a postgres command to list/drop all materialized views?

I am creating multiple views in my code and each time the code is run, I would like to drop …

database postgresql ddl materialized-views
materialized view creation is fast but refresh takes hours

I am using a materialized view, and I cant set it to fast refresh because some of the tables are …

oracle plsql oracle10g materialized-views
MySQL not using index with JOIN, WHERE and ORDER

We have two tables resembling a simple tag-record structure as follows (in reality it's much more complex but this is …

mysql join indexing sql-order-by materialized-views
What is the difference between complete refresh and fast refresh in materialized view?

I have materialized view in my own schema and the materialized view source is the other schema table but , this …

oracle rdbms materialized-views
Oracle Disable Materialized View Refresh

Anyone have the syntax to disable the refresh of a materialized view in Oracle? I struggle with the Oracle documentation …

oracle materialized-views
Refreshing an existing materialized View

I created a materialized view with the following information. CREATE MATERIALIZED VIEW EMPLOYEE_INFO AS SELECT * FROM EMPLOYEE_TABLE WHERE …

oracle materialized-views
Check last refreshed time for materialized view

I've got a materialized view called price_changes used for some reporting. I've also got a cron job refreshing the …

postgresql materialized-views
Refresh materialized views with concurrency

I have a PostgreSQL DB, where I use materialized views. The problem occurs when I try to refresh these materialized …

postgresql materialized-views