How to reduce skew for small table

Database

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

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.

Re: How to reduce skew for small table

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

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.