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
No comments:
Post a Comment
Thank you :
- kareem