Takeaway

You now have a checklist of modeling practices to ensure optimal performance for SAP HANA information models, including guidelines for creating optimal SQL and SQLScript.

You have learned how to use the Explain Plan tool to identify the execution engines used and the Visualize Plan tool to find the time taken and number of records returned for every step in a query.

You can use the Administration Console to identify long-running and expensive statements and to perform traces of specific queries and user activities. Performance Analysis Mode helps improve your SAP HANA information models by providing optimization suggestions.