Hello All,
If I have set degree of parallelism (DOP) at database level, then it means any select, DML operation performed on any table will be executed in parallel fashion in multiple threads?
What are advantages and disadvantages of DB level DOP.
What is pros and cons of object level DOP and when preferred over DB level DOP.
what are pros and cons of automatic degree of parallelism and when it is preferred over other kind of parallelism.
When I define DOP at ODI then is it mandatory to define at DB level as well?
Thanks,
Rajneesh