PLW-07202: bind type would result in conversion away from column type

PLW-07202: bind type would result in conversion away from column type
Cause: The column type and the bind type do not exactly match. This will result in the column being converted to the type of the bind variable. This type conversion may prevent the SQL optimizer from using any index the column participates in. This may adversely affect the execution performance of this statement.
Action: To make use of any index for this column, make sure the bind type is the same type as the column type.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:45

PLW-07202：绑定类型将导致转换离开列类型,
.原因：列类型和绑定类型不完全匹配。这将导致列被转换为绑定变量的类型。此类型转换可能会阻止SQL优化程序使用列所参与的任何索引，这可能会对此语句的执行性能产生不利影响。,
.操作：要使用此列的任何索引，请确保绑定类型与列类型相同。,
.

aiaiDBA

13718043309

010-86462881

PLW-07202: bind type would result in conversion away from column type

1 个回答

相似问题