What are three advantages provided by proper partitioning in a data warehouse?
A.
Partition pruning will occur
B.
Faster sorting
C.
Efficient parallel joins
D.
Efficient data loading
E.
Reduced disk usage
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.
Reference:
http://www.databasejournal.com/features/oracle/article.php/3317621/A-Practical-Guide-to-DataWarehousing-in-Oracle—Part-3.htm