Stack Overflow
Stack Overflow

Questions tagged [materialized]

61 questions
0
votes
1 answer

How to do automatic refresh of materialized views

I want to automatically refresh the materialized view after the data is insert to tables when creating a materialized view. I tried the following code (refresh complete start with Creating materialized view that refreshes every 5 min )but not…
Gül ÖZCAN
  • 15
  • 6
0
votes
1 answer

How to add Materialized Views in rails 5

I want to add a Materialized Views for avg rating. My Rate model is: class Rating < ApplicationRecord belongs_to :post validates_presence_of :rate validates_inclusion_of :rate,in: 1..5 end My Post Model is: class Post < ActiveRecord::Base …
NAREN PUSHPARAJU
  • 165
  • 12
0
votes
1 answer

Side nav doesn't work on mobile view

Side nav works fine, but when I click on any button on it auto scroll isn't working. all links are not working.
0
votes
0 answers

Order heirarchical data alphabetically? (I've a working query that can be optimized too)

Alright, so I've looked EVERYWHERE about how to sort/order hierarchical data with some sort of arbitrary value, like alphabetically, highest votes, etc. Do any of you have any solutions for a nested set or something else? Here's a couple example…
Thrash Tech
  • 21
  • 1
  • 4
0
votes
1 answer

Can't create materialized view with a join and group-by

I'm trying to create a materialized view with a left outer join and a group by. I'm getting this error: Error report - ORA-12015: cannot create a fast refresh materialized view from a complex query 12015. 00000 - "cannot create a fast…
Batman
  • 5,563
  • 18
  • 79
  • 155
0
votes
1 answer

Pagination of custom materialize projects does not work for me

The list of sub-pages does not work for me on the official demo sites: Materialized Materialize(css) Neither navigation bar changes the active page number (or content). Both websites use materialize css. For an example, just click one of these…
datascientist42
  • 24
  • 6
0
votes
0 answers

Oracle 11g2 Materialized View not refresh (Insert or Update) as per given schedule

I have created the materialized views using DB link. I am facing an strange problem with Oracle 11g2 materialized view. When invoke first time sometimes it does not reflect the changes(insert and update) as per source table changes. When invoke the…
sandeep pandit
  • 111
  • 1
  • 1
  • 7
0
votes
1 answer

Way to improve performance of materialized view refresh

I have a materialized view that brings back 2 columns and roughly 300m rows. The materialized view is based on joins between multiple views. Currently it takes roughly 10 minutes for this to refresh and I am trying to improve the refresh time since…
AAA
  • 2,388
  • 9
  • 32
  • 47
0
votes
1 answer

Materialized View With Monthly Substitute Variables

I am trying to reconfigure a View into a materialized view for summary roll-ups. IS there a way to implement the process so that I can gather each months parameters from the materialized view easily without having to run Substitute variables each…
Tinkinc
  • 449
  • 2
  • 8
  • 21
0
votes
4 answers

materialized / meteor - select form is not working

I'm trying to use materialized select form on my Meteor app but it seems not working.... Here is my code: html