Feature Information
| Feature Number | 701047a |
| Overview | When there is a JOIN directly below a GROUP BY based on LPN, a feature is added to push the GROUP BY down below the JOIN to improve performance. |
| Details | The GROUP BY is pushed down below the JOIN when all the following conditions are met. The JOIN is an FK-PK relationship. The key connecting FK-PK is used as a condition. The GROUP BY keys are more numerous than the FK-PK keys used in the JOIN, resulting in finer grouping. Only the FK side expressions are used in the GROUP BY expression. The JOIN is either INNER or LEFT OUTER JOIN. In the case of LEFT OUTER JOIN, the GROUP BY is pushed down to the FK side child node. This reduces the number of rows required for the JOIN, thereby improving performance. |
| Occurrence Date | June 22, 2026 |
| Patch Required Version | 7FS02PS |
Patch Information
| Patch Name | FS02PS_701047a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | groupby pushdown feature added |
| Release Date | August 24, 2026 |
| Compatibility | โข TAC rolling patch: Supported โข TSC rolling patch: Supported โข Backup data compatibility: Supported โข Protocol compatibility: Supported โข Data format compatibility: Supported |
| AP Impact | โข Plan change: Yes โข Result value change: No โข SQL syntax change: No โข System object change: No โข Existing feature change: No |
| Parameters | - |
| Workaround | - |