Hello,
Thanks for this clear explanation !
Then I have a sub-question :
Supposed I have 3600 materialised views say 600 mat views from 6 main table. (A,B,C,D,E,F are repetead 600 times with some differences)
Is it faster to :
1) parallel refresh 600 time A, then 600 time B etc,
OR
2) parallel refresh 600 time A,B,C,D,E,F
I guess 1) is faster because they are 600 access to same table loaded in memory ? But do parallel access to the same table implies concurency
and bad performance ?
Thanks