Friday, 10 August 2012

Which statement is true about partitioned primary indexes (ppl)? | Teradata

A. ppl is beneficial in queries specifying range constraints.
B. Ppl is used to enhance performance against small tables.
C. They reduce the number of rows processed by using partition elimination.
D. To store rows using  PPL you specify partitioning in the CREATE TABL statement.

ANS: A,C

No comments: