Tuesday, September 6, 2011

What is the acceptable range for skew factor in a table?


There is no particular range for skew factor.  In case of production systems, it is suggested to keep skew factor between 5-10. 
There are various considerations for skew factor
- Number of AMPS
- Size of row in a table
- number of records in a table
- PI of a table
- Frequent access of table (Performance consideration)
- whether table getting loaded daily /monthly or how frequently data is being refreshed

No comments:

Post a Comment