Skewfactor

Database
KVB
Enthusiast

Skewfactor

Hi ,

I fired the below query on a table and got 0.57 as the skew factor.Is it tolerable or not?

select tablename,

sum(currentperm)/(1024*1024) as Currentperm,

(100-(avg(currentperm)/max(currentperm)*100)) as skewfactor

from

dbc.tablesize

where databasename='DBNAME'

and tablename='TABLENAME'

group by 1

Tags (1)
1 REPLY
Senior Supporter

Re: Skewfactor

Values < 1 are OK. You might not getting better even if you use a UPI - depending on your number of rows and number of vprocs. 

But as so often there are no fix numbers to say what is acceptable and what is not. 

Sometimes skew of 10 can be accepted in case is serves a very good access pattern and data would be redistrubuted to this pattern in the majority of the SQLs accessing this table. Sometimes a skew of 5 can be reviewed - if it is the biggest table of the system.

A good starting point for making decissions it the difference between max(currentperm) * #vprocs - sum(currentperm - which shows you the space "waisted". If this is big and you can't justify the PI as a good access path consider to check for a new PI.

Ulrich