10 Optimization of Information Models

Techniques You’ll Master


During our exploration of SAP HANA, we’ve frequently come across the topic of performance. SAP HANA is well-known for the improvements it brings to business process runtimes and its real-time computing abilities.

In this chapter, we’ll discuss some of these performance enhancements built into SAP HANA and review the techniques you’ve learned previously. We’ll then look into new ways of pinpointing performance issues and discuss how to use the optimization tools built into SAP HANA.

Finally, we’ll examine some guidelines and best practices when modeling and writing SQL and SQLScript code.

Real-World Scenario

The CEO of your company reads a 2009 study by Akamai that says that 40 percent of online shoppers will abandon a website that takes longer than three seconds to load.

Therefore, you are tasked to help achieve a response time of less than three seconds for most reports and analytics that sales representatives use. Many such users work on tablets, especially when they are visiting customers. You decide to use a mobile-first approach, creating interactive analytics and reports to reduce network requirements.

Some of the reports currently take more than two minutes to run on SAP HANA. Using your knowledge of optimization, you manage to bring these times down to just a few seconds.

Objectives of This Portion of the Test

The purpose of this portion of the SAP HANA certification exam is to test your knowledge of the SAP HANA modeling tools.

The certification exam expects you to have a good understanding of the following topics:

[»] Note

This portion contributes up to 10% of the total certification exam score.