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
0
votes
1 answer

flexview illegal mix of collations error

I try to setup flexview to have support of materialize view in foor MySQL, but this error occurred : PHP Strict standards: Non-static method PEAR::isError() should not be called statically, assuming $this from incompatible context in…
Arash Mousavi
  • 2,110
  • 4
  • 25
  • 47
0
votes
1 answer

ORA: 12054 Creating Materialized View with UNION ALL

I seem to get ORA: 12054 when I do this action. I would really appreciate some help. Thank you create table daniel (id number, name varchar2(40)); alter table daniel add constraint daniel_pk primary key(id); create materialized view log on daniel…
Amaros
  • 503
  • 5
  • 20
0
votes
0 answers

Oracle 11gR2 MView refresh failing

Hi I have created 5 MViews for tables in Remote DB 2 days back in production environment. Out of that one Mview, at the time of creation it worked fine. But 2 days after(today) the MView's last refresh date is still showing the day before…
explorer da
  • 97
  • 1
  • 7
0
votes
1 answer

Creating a Materialized View with Fast Refrese on Oracle 11g

I have a weird problem while creating a materialized view on a table with alot of columns, indexes and constraints. I tried running the command: CREATE MATERIALIZED VIEW mvX PARALLEL BUILD IMMEDIATE REFRESH FAST AS SELECT * FROM table_name After…
user967710
  • 1,815
  • 3
  • 32
  • 58
0
votes
1 answer

Materialized view log size > 0, when REFRESH is set as ON COMMIT

I have a straight forward materialized view across about 8 master tables. create materialized view MV REFRESH FAST ON COMMIT as SELECT... I am also running this query to keep an eye on the materialized log sizes. select segment_name, SUM (…
Moz
  • 1,494
  • 6
  • 21
  • 32
0
votes
5 answers

Materialized view with Oracle

I have the following line in a script and I don't understand what the "using" part is used for. I couldn't find anything on google. Anybody familiar with that ? Thanks a lot !! CREATE MATERIALIZED VIEW "PVTRNDM"."DM_MVW_DAILY_CAL" USING…
Vincent
  • 510
  • 1
  • 5
  • 23
0
votes
2 answers

Help needed for optimizing linq data extraction

I'm fetching data from all 3 tables at once to avoid network latency. Fetching the data is pretty fast, but when I loop through the results a lot of time is used Int32[] arr = { 1 }; var query = from a in arr select new { …
Henrik
  • 5
  • 1
0
votes
1 answer

Update materialized view in oracle 11g

I want to update materialized view every 5 min such that it does a delta update not a full update. Can i use last modified date, and just update data that has been updated? my question is: 1) how to do update every 5 minute? 2) how to do just a…
user2367636
  • 59
  • 1
  • 1
  • 4
0
votes
2 answers

Oracle materialized view computational cost

Is the computational cost of updating a stored procedure materialized view, in Oracle, based on the query execution or the result set? More specifically, does Oracle store the results of the query in such a way that contributes significantly to the…
Sean Connolly
  • 5,692
  • 7
  • 37
  • 74
0
votes
2 answers

Query/Database Optimization: How to optimize this? (and should I use a materialized view?)

I have a question on how to optimize a query. Actually, as I'm going to be running the query frequently, I was thinking of using a materialized or indexed view (is this a good idea here?) or denormalizing. Consider the following four tables (with…
Robert Fraser
  • 10,649
  • 8
  • 69
  • 93
0
votes
2 answers

Query performance on materialized view vs master tables

I am afraid of strange behavior in db, on my master tables UDBMOVEMENT_ORIG (26mil.rows) and UDBIDENTDATA_ORIG (18mil.rows) is created materialized view TMP_MS_UDB_MV (UDBMOVEMENT is synonym to this object) which meets some default conditions and…
Metelesku 33
  • 13
  • 4
0
votes
1 answer

Oracle Materialized View: update MVs in the remote db?

I created a fast refresh MV in a remote db by using a syntax like follows: CREATE MATERIALIZED VIEW MV_TAB1 REFRESH FAST WITH PRIMARY KEY START WITH SYSDATE NEXT SYSDATE+(5/1440) /* 5 MINUTES */ FOR UPDATE AS SELECT * FROM TAB1@SOURCE_DB; Now…
Amos
  • 23
  • 5
0
votes
1 answer

Unity 3d - Material Selection for Rendering

I am trying to change the Material of wall at run time. I import the model of house from Google Sketchup, which has different materials all in one object (this is shown in the inspector). Whenever I click the next button (>>), it changes the first…
Master143
  • 1
  • 1
  • 2
0
votes
1 answer

Truncate oracle mview without affecting queries

I have a couple of MVs in an Oracle 11g database which full-refresh swiftly when not atomic. A new requirement means that they must be. I understand that when not-atomic DBMS_MVIEW.REFRESH performs a truncate before a series of inserts but when…
John Colman
  • 1
  • 1
  • 1
0
votes
1 answer

Quering Oracle materialized view - column ambiguously defined

I have a trouble querying view in Oracle. Here is the view (my_cool_view) definition: SELECT * FROM mview1 JOIN mview2 USING(col_id) where mview1 and mview2 is materialized views. I can't access to definition of this materialized…
Kai
  • 2,023
  • 7
  • 28
  • 49
1 2 3
…
55 56