standards for parallelism
hi,
may i ask for your help in applying a standardization when applying parallelism in a datawarehouse? or any feature in 11gR1 that can help me apply effective parallelism in tables having more than 400M records..
1. Statement Level
2. Object Level
is this effective?
Num of rows DEGREE
< 100,000 1
100,000 – 10,000,000 2
10,000,000 – 100,000,000 4
100,000,000 – 10,000,000,000 6
10,000,000,000 – 100,000,000,000 8
for example:
when it comes to using statements using multi level queries how will the logic of using the degree of parallelism work?
thanks.