Issue Number : 700462a
| Issue | In environments where the _OPT_BIND_PEEKING option is disabled, unnecessary ORDER BY nodes are included in the execution plan. |
| Cause | When it is difficult to clearly determine the type information of a Bind Parameter, a conservative handling method was applied during the execution plan generation process. As a result, in some conditions, nodes that are not actually required for processing could be included in the execution plan. |
| Solutions | The logic has been improved so that, during the execution plan generation process, if the type information of a Bind Parameter can be determined, that information is preferentially utilized. The existing handling method is maintained only when type information cannot be confirmed, minimizing unnecessary differences in the execution plan. This improvement is not limited to specific environments and maintains compatibility with existing behavior. |