Stack Overflow
Stack Overflow

Questions tagged [materialized-views]

A materialized view is a database object that contains the results of a query. They can be local copies of data located remotely, or can be used to create summary tables based on aggregations of a table's data. Materialized views are also known as snapshots.

A materialized view is a database object that contains the results of a query. They can be local copies of data located remotely, or can be used to create summary tables based on aggregations of a table's data. Materialized views are also known as snapshots.

When posting questions with the materialized-views tag please add another tag with the RDBMS involved(Oracle, Sql Server, etc.)

Oracle's Materialized Views documentation here

839 questions
-1
votes
1 answer

Postgresql materialized view efficient with many refreshes?

Does the postgresql materialize view rebuild the entire table on a REFRESH command? Is it efficient to TRIGGER a refresh to a materialized view that is dependent on a table with heavy writes?
Brian Yeh
  • 3,119
  • 3
  • 26
  • 40
-1
votes
2 answers

How to fix the materialized view on counts with multiple joins?

I am optimizing a query using materialized view in PostgreSQL but query logic is not working in mat view I want to optimize the query which involves multiple joins and its execution time also higher, so I tried the same query in Materialized view…
prabhu
  • 103
  • 1
  • 3
  • 15
-1
votes
1 answer

ORA-08103: object no longer exists - Materialized view

I'm selecting from a standard view (view1) which references a materialized view (mview1). The standard view is created with "FORCE" option and the materialized view is created "REFRESH COMPLETE ON DEMAND". As I don't know when the materialized view…
xavier
  • 177
  • 3
  • 15
-1
votes
1 answer

SQL developer create materialized views

I want to create a materialized view with oracle SQL developer It should refresh hourly So i do this: If it understand correctly, by setting "SPECIFY" as "When", and by setting 13:00:00 as "Start on" and 14:00:00 as "Next", the MV should refresh…
Maik
  • 811
  • 3
  • 22
  • 35
-1
votes
2 answers

Can I disable QUERY OPTIMIZATION for MQT in DB2 LUW without recreating it?

UPDATE from 2021 This question is no longer actual for me. It was a short period when I worked with DB2 and I don't know how it's in recent versions. The problem was: I could not test effect of MQT without rebuilding it. Which was not practical when…
Alex Yu
  • 3,412
  • 1
  • 25
  • 38
-1
votes
1 answer

escape single quote in stored proc in oracle

I have a requirement where I have extact the ddl for materialized view and execute it. I have create script for a materialized view as follows : CREATE MATERIALIZED VIEW "XXX"."AUD_MV_DCST" ("BUCKET", "ID", "SUM") ORGANIZATION HEAP PCTFREE 10…
user1860447
  • 1,316
  • 8
  • 25
  • 46
-1
votes
1 answer

Does Cassandra 3.0 provide Materialized Views

I am happy that Cassandra 3.0 is out now and thought i'd check the documentation. This documentation page states that 3.0 offers support for materialized views. Is this feature still in progress (why then stated in the "new features" section?) or…
M156
  • 1,044
  • 1
  • 12
  • 29
-1
votes
1 answer

View Queries taking forever

I have several Oracle Database Views that have some fairly complex queries that are used often in my web-application. The query takes a good 10-25 seconds to compute and then there is some backend Java processing on the data which makes it even…
Brandon Wagner
  • 893
  • 9
  • 27
-2
votes
1 answer

Can this materialized view be fast refreshable?

CREATE MATERIALIZED VIEW TEST BUILD IMMEDIATE REFRESH COMPLETE ON DEMAND AS WITH test1 AS ( SELECT EMPY_UID, PRDE_UID, PRDE_DATDEBMVT, PRDE_DATFINMVT, DAT.DATES V_DATCPT …
Aymen
  • 1
-2
votes
2 answers

How to implement Materialized View in SAP HANA SP12

How to implement Materialized View in SAP HANA? Is it possible to create a materialize in SAP HANA SP12
Prathamesh H
  • 152
  • 5
  • 23
-2
votes
1 answer

Can I create a Materialized View using JPQL or using Criteria Query? If yes, what is the way to do that?

I'm working on creating Materialized View, but I'm using JPA as ORM. One way to create a Materialized view is by using native sql query. But I have to create a Materialized View using JPQL or using Criteria Query. Is it possible? If it is, then…
Bhupendra
  • 11
  • 1
-2
votes
2 answers

java web security

Let me explain the problem. So, there is a data base which is pivotal for many app and I need to keep it safe. Also, I do not want to access that data base directly. I think of using materialized view. Is that a good solution? I need some…
Thales Ribeiro
  • 53
  • 4
-3
votes
1 answer

How to get data from Indexed view?

I have created Indexed view - let's call it PostBank. I keep there Id, CategoryName and UserId. How I get data from PostBank to controller? Thank You for Your time ;) SQL command work perfectly, i tested. But I dont know is here possible to use…
Aaron
  • 17
  • 8
-5
votes
1 answer

which is best for designing forum website - bootstrap or materialize?

I want to design a forum. what is best frontend framework between bootstrap and materialize.
Albert Teja
  • 9
  • 1
1 2 3
…
55
56