materialized-view Archives

Query the definition of a materialized view in Postgres

By adminPosted on March 12, 2023

Question : I’m wondering how to query the definition of a materialized view in Postgres. For reference, what I hoped […]

By adminPosted on March 10, 2023

Question : This question already has answers here: Best way to create a materialized view in MySQL (3 answers) Closed […]

By adminPosted on March 1, 2023

Question : So I essentially have two tables in a database. One which is the base table of all of […]

By adminPosted on February 24, 2023

Question : New to this topic – in my current environment we are not doing any replication but we use […]

By adminPosted on February 23, 2023

Question : I’m trying to drop a view, of which I cannot assure whether it is a MATERIALIZED VIEW or […]

By adminPosted on February 19, 2023

Question : I have tried DBMS_ADVISOR.TUNE_MVIEW to verify some materialized views created locally. One of the result returns an error: […]

By adminPosted on February 16, 2023

Question : I know how to check the size of indexes and tables in Postgres (I’m using version 9.4): SELECT […]

By adminPosted on January 31, 2023

Question : I need to get metadata about all MATERIALIZED VIEW columns, including their data type. I can do this […]

By adminPosted on January 30, 2023

Question : I have setup SQL Server transactional replication, and then added indexed views at the subscriber, but the indexed […]

By adminPosted on January 24, 2023

Question : I have a materialized view with an unknown column name, and I need to give that column a […]