PrepAway - Latest Free Exam Questions & Answers

Which actions could improve the performance of those queries?

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply