C-D: ADW the majority of the memory is allocated to the PGA to allow parallel joins and complex aggregations to occur in memory, rather than spilling to disk. While on ATP the majority of the memory is allocated to the SGA to ensure the critical working set can be cached to avoid IO.
Not b, because the question asks about index storage not index usage. Both ATP and ADW store indexes in the same way although they do not use indexes in the same way.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Hernando
Highly Voted 3 years, 6 months agoClimberBear
Highly Voted 3 years, 5 months agomedusarose
3 years, 5 months agoguru_ji
Most Recent 1 year, 6 months agoLewora
2 years, 11 months agoPKD4OCI
3 years agooracle1239
3 years, 2 months agoMinghon
3 years, 2 months agoVishwasS
3 years, 2 months agoVishwasS
3 years, 2 months agoHeke
3 years, 5 months ago