IGATE interview question

Explain Performance Tuning, Statement Execution at the Architecture level