What are three advantages provided by proper partitioning in a data warehouse?

The correct answer is A. Partition pruning will occur C. Efficient parallel joins D. Efficient data loading. There are three major advantages of partitioning. Partition Pruning - Oracle only accesses a limited set of table partitions if the FROM and WHERE clause permit it to. Partition-wise Joins - Where two tables that have compatible partitioning schemes are joined , Oracle improves t

Partitioning

Question

Options

APartition pruning will occur
BFaster sorting
CEfficient parallel joins
DEfficient data loading
EReduced disk usage

How the community answered

(35 responses)

A
71% (25)
B
20% (7)
E
9% (3)

Explanation

There are three major advantages of partitioning. * Partition Pruning - Oracle only accesses a limited set of table partitions if the FROM and WHERE clause permit it to. * Partition-wise Joins - Where two tables that have compatible partitioning schemes are joined , Oracle improves the efficiency of parallel operations by performing the join between individual partitions of the tables. * Manageability - Partitioning allows DDL operations on a large subset of table rows with some element of commonality defined through the partitioning type. Warehousing-in-Oracle---Part-3.htm

Topics

#partition pruning#parallel joins#data loading#partitioning benefits

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice