Feature Information
| Feature Number | 701301a |
| Overview | The goal was to improve performance by identifying performance inefficiencies that occurred when loading statistical information. |
| Details | Optimized inefficient logic that repeatedly allocated and deallocated memory when querying statistical histograms. Improved query performance by using the DD cache for histograms instead of the internal SQL method when querying histograms. |
| Occurrence Date | 26.08.20. |
| Required Patch Version | 7FS02PS |
Patch Information
| Patch Name | FS02PS_701301a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | Hard Parsing Performance Improvement - Statistics Load Performance Optimization |
| Available for Release | 26.09.17. |
| Compatibility | • TAC rolling patch: Available • TSC rolling patch: Available • Backup data compatibility: Available • Protocol compatibility: Available • Data format compatibility: Available |
| AP Impact | • Plan change: No • Result value change: No • SQL syntax change: No • System object change: No • Existing functionality change: Yes |
| Parameter | - |
| Workaround | alter session set _OPT_STATS_LOAD_USE_DD_CACHE=N; |