IGATE Interview Question

Explain Performance Tuning, Statement Execution at the Architecture level