If I put my question in Short and Simple manner, that ends up saying - "Want to know Details about Tuning and Optimization".
Briefly, I can go for a google search but the result I was looking for a consolidated one - like Black Book in teradata with Details how load distribution take place( load distribution in AMPs).
Things we must keep in mind while coding and designing( to avoide Spool space error, not modifying the quary blindly rather a definete approach).
In a nutshell how to get in a fight with a DBA and win it all over ( pardon me if i sound little bit Ambicious) :)
I would recommend PRISE Tuning Assistant to investigate performance problems, you can get a full functional free trial here: https://www.prisetools.com/productrequest