Feature Information
| Feature Number | 701015c |
| Overview | SFC (Simple Filter Condition) is a feature that processes filters that simply compare a column and a constant in the WHERE clause through a fast path. Previously, it was applied only when all conditions in the WHERE clause were SFCs. This patch removes that restriction, expands the supported types and nodes, and improves the feature to also process conditions that require column casting for comparison. This allows the benefits of the SFC path to be partially utilized even in queries that mix SFC and complex conditions. |
| Details | Change the default value of _USE_NEW_SFC from Y to N. |
| Occurrence Date | 26.07.21. |
| Required Patch Version | 7FS02PS |
Patch Information
| Patch Name | FS02PS_701015c |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | Change the default value of _USE_NEW_SFC to N |
| Available for Deployment | 26.07.23. |
| Compatibility | • TAC rolling patch: Yes • TSC rolling patch: Yes • Backup data compatibility: Yes • Protocol compatibility: Yes • Data format compatibility: Yes |
| AP Impact | • Plan change: No • Result value change: No • SQL syntax change: No • System object change: No • Existing feature change: Yes |
| Parameter | - |
| Workaround | - |