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.

Where are histograms useful in the SAP environment?

April 26, 2017Environment histograms SAP useful

0

Posted

Where are histograms useful in the SAP environment?

1 Answer

0

Posted

RSDD_TMPNM_ADM (Note 802299) LTAP / LTBP (Note 811852) MSEG / MKPF (Note 902157, 902675) PPC_HEAD BDCP / BDCPS (Note 706836) F4 search help (Note 1008433) Additionally, histograms are sometimes used for objects of the Oracle DDIC as of Oracle 10g (in connection with the statistics creation that is described in Note 838725). 16. Why is ENDPOINT_ACTUAL_VALUE in DBA_TAB_HISTOGRAMS partially unfilled? The ENDPOINT_ACTUAL_VALUE contains the endpoints of individual histogram buckets in readable form. Therefore, it is suitable for analyses of optimizer decisions in connection with histograms. However, this column is not always filled. DBMS_STATS statistics in particular do not often fill this column. This is not a matter of a bug, but rather the normal behavior (compare information from Oracle bug 3333781), since ENDPOINT_ACTUAL_VALUE is only intended for Oracle-internal purposes. 17. What problems are there regarding histograms? The following problems may occur when you use histograms: With