Q. What are different types of views in HANA? Ans. 1. Attribute view 2. Analytic view 3. Calculation View 4. Decision Table For the purpose of taking business informed decisions and they run on top of HANA DB doing code- pushdown or functional pushdown to the DB layer Q. What is the function of SQL optimizer?