Tagged Questions
1
vote
0answers
23 views
Monoblock, Multiblock queries?
What exactly mean the terms monoblock / multiblock queries in data warehouses when talking about materialized views? Does a monoblock query just use one data source (a normal table) while a multiblock ...
1
vote
2answers
608 views
Materialized View - Oracle
I have materialized view for which i want to alter its refresh time:
REFRESH FORCE START WITH SYSDATE NEXT SYSDATE +1 DISABLE QUERY REWRITE
I want to know few things in this.
What does NEXT ...
2
votes
2answers
777 views
WITH using INDEX hint in Oracle
I have a fairly complicated query. I have written two different query to accomplish my goal.
First one is using WITH, other one is using global temporary tables.
First One:
WITH A
(
KNO
..
)
, ...
5
votes
2answers
630 views
Using totals on aggregates to improve performance
I have two tables: details and totals of these details.
Details (Slow solution):
select
OrderId = r.OrderId
, TotalQty = SUM(r.Quantity)
, ...
