How to Avoid redistribution

Database
Enthusiast

How to Avoid redistribution

Hi,

I have Join condition in the query having one of the column is skewed. The Explain Plan is showing 3 Min time only

at this join. 

Can anybody help me solve this.

LEFT JOIN

(

SELECT 

COL1, COL2

FROM

(

TABLE A ,

TABLE B,

TABLE C

WHERE A.COL1  =  B.COL2   /* HERE A.COL1 IS HIGHLY SKEWED */

AND     B.COL     =  C.COL

AND    A.COL      =  C.COL

)

Thanks,

Suresh.