I need help in deciding subquery is better or a join ???
Select Res_ID
from mwebRes
where Res_Status <> 20 AND Res_Entity_Type = 3
AND (Res_ID IN (Select AuthAttr_Res_ID
From MwebAuthAttrib
AND (AuthAttr_Work_ID IN
(Select Work_ID
From MwebWork
Where DECODE(inWorkLevel,2,Work_Par2,3,Work_Par3,4,Work_Par4,5,
Work_Par5,6,Work_par6,7,Work_par7 ,8 ,work_par8,Work_Par9 ) = inProject
AND Work_Entity_Type = 4 AND Work_Status <> 40))
AND AuthAttr_Role_ID = inRole));
------------------------------------------------

Select a.Res_ID
from mwebRes a, AuthAttr_Res_ID b, mwebwork c
where a.Res_Status <> 20 AND a.Res_Entity_Type = 3
AND a.Res_ID =b.AuthAttr_Res_ID
AND b.AuthAttr_Work_ID =c.Work_ID
and DECODE(inWorkLevel,2,c.Work_Par2,3,c.Work_Par3,4,c.Work_Par4,5,
c.Work_Par5,6,c.Work_par6,7,c.Work_par7 ,8 ,c.work_par8,c.Work_Par9 ) = inProject
AND c.Work_Entity_Type = 4 AND c.Work_Status <> 40
AND b.AuthAttr_Role_ID = inRole;

Which one is faster ??
What is the sequence of execution ?