Which query is better inner join or in???

[marist89]

Couple points:
1. lots of sorts going on
2. why mess around with IN anyway, just join.
3. as you know, the to_char() will kill you
4. lets see a tkprof with timing and wait events