You will learn
- Creating table statistics.
- Analyzing the effect of table statistics on query plans.
By Balkarann
Create table statistics. Analyze impact of statistics on query plans.
SAP HANA and Dynamic Tiering relies on statistics in order to help the optimizer choose the most effective access plan. Creating statistics is particularly important for queries involving Dynamic Tiering as they help SAP HANA determine when it is appropriate to use optimizations like joinRelocation
or SemiJoin
rules. These query operators help SAP HANA and Dynamic Tiering minimize the volume of data (# of rows & column values) transferred between the core SAP HANA and Dynamic Tiering nodes.
Updated 10/05/2017
Contributors Provide Feedback
20 Min.