You have enabled data partitioning on your High-Volume Server installation. You need to perform a number of operations on a large set of objects using DQL. Which actions could improve the performance of those queries?
A. Retrieve the r_object_id and shared_parent_type properties of the objects. Use both properties in the WHERE clause of subsequent queries.
B. Retrieve the r_object_id and i_partition properties of the objects. Use both properties in the WHERE clause of subsequent queries.
C. Execute the GENERATE_PARTITION_SCHEME_SQL administrative method just before executing the queries.
D. Retrieve the r_object_id and shared_parent_type properties of those objects. Execute the GENERATE_PARTITION_SCHEME_SQL administrative method. Use both properties in the WHERE clause of subsequent queries.
|
Download Printable PDF. VALID exam to help you PASS. |
 |