Itanium 1.2Ghz + 1GB RAM  vs Dual Xeon 2.8Ghz HT + 2GB RAM

i have shortened the query so hopefully easier to understand

select * from A 

left join 

 (

 select * from...