Feature Information
| Feature Number | 701015d |
| Overview | SFC (Simple Filter Condition) is a function that processes filters which simply compare columns and constants in the WHERE clause through a fast path. Previously, this was applied only when all conditions in the WHERE clause were SFC. However, this patch removes that restriction, expands supported types and nodes, and enhances processing to handle conditions requiring column casting during comparison. Through this, the benefits of the SFC path can be partially utilized even in queries mixing SFC and complex conditions. |
| Details | Parameter Disclosure The feature control parameter is provided as a public parameter named USE_NEW_SFC. The default value is N, recommended value is Y, and it can be changed dynamically at the session level. |
| Effective Date | 07/26/23 |
| Required Patch Version | 7FS02PS |
Patch Information
| Patch Name | FS02PS_701015d |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | SFC IPRAM Modification |
| Release Date | 07/26/25 |
| Compatibility | • TAC rolling patch: Supported • TSC rolling patch: Supported • Backup data compatibility: Supported • Protocol compatibility: Supported • Data format compatibility: Supported |
| AP Impact | • Plan change: No • Result value change: No • SQL syntax change: No • System object change: No • Existing feature change: Yes |
| Parameter | • Parameter Name: USE_NEW_SFC • Type: UPDATE • Tip Type: DB • Description: Feature name: Activate SFC performance improvement Y: After SFC performance improvement N: Before SFC performance improvement • Parameter Type: Boolean • Default Value: N • Class: Optional, Adjustable, Dynamic, SESSION • Range: - |
| Workaround | - |