Tuesday, February 15, 2011

What are the basic criteria to select Primary Index column for a given table?

What are the basic criteria to select Primary Index column for a given table?
Answer:

A thumb rule of ADV demographics is followed.
Access Demographics
Identify index candidates that maximize one-AMP operations.
Columns most frequently used for access (Value and Join).

Distribution Demographics
Identify index candidates that optimize parallel processing.
Columns that provide good distribution.

Volatility Demographics
Identify index candidates with low maintenance I/O.

No comments:

Post a Comment