PrepAway - Latest Free Exam Questions & Answers

Which methods are available to optimize a projection for delete processing?

Which methods are available to optimize a projection for delete processing? (Select two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Add a low cardinality column to the beginning of all projections on the source table.

B.
Add a high cardinality column to the end of all projections on the source table.

C.
Add all columns used as delete predicates to all projections on the source table.

D.
Add a low cardinality column to the end of all projections on the source table.

E.
Add a high cardinality column to the beginning of all projections on the source table.

Explanation:


Leave a Reply