How to reduce skew for small table

Database
Enthusiast

How to reduce skew for small table

Hi All,
I have small table which has 30000 records and server has 144 Amps and table is having UPI .Still it is having skew factor around 20.54 .I want to reduce it to less than 5
3 REPLIES
Junior Supporter

Re: How to reduce skew for small table

Hi.

 

>>"I want to reduce it to less than 5."

 

Why? You have an UPI already. Skew is generally unimportant for small tables (you could even study to allocate small tables in one amp to reduce IO).

 

Cheers.

 

Carlos.

Enthusiast

Re: How to reduce skew for small table

I tried with that option then skew factor got increased to 84 .
Junior Supporter

Re: How to reduce skew for small table

Hi.

 

>>"I tried with that option then skew factor got increased to 84 . "

 

Sure it did!

But this is a way to reduce I/O, not skew!

 

Cheers.

 

Carlos.