Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What does the /+ SHORT_SUM_VALUES / hint mean in BW queries?

April 26, 2017Hint mean queries

0

Posted

What does the /*+ SHORT_SUM_VALUES */ hint mean in BW queries?

1 Answer

0

Posted

This hint is not relevant for the strategy and therefore does not have any effect on the query processing sequence. This hint ensures that, when the totals are being formed using the columns, the actual length of a numeric field is used for the calculation rather than the maximum field length. For more information, see Note 723020. In relation to the hints, see also Notes 652096 and 832544.