PLW-07204: conversion away from column type may result in sub-optimal query plan

PLW-07204: conversion away from column type may result in sub-optimal query plan
Cause: The column type and the bind type do not exactly match. This may 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-07204：从列类型转换可能会导致次优查询计划,
.原因：列类型和绑定类型不完全匹配。这可能导致列被转换为绑定变量的类型。此类型转换可能会阻止SQL优化程序使用列所参与的任何索引，这可能会对此语句的执行性能产生不利影响。,
.操作：要使用此列的任何索引，请确保绑定类型与列类型相同。,
.

aiaiDBA

13718043309

010-86462881

PLW-07204: conversion away from column type may result in sub-optimal query plan

1 个回答

相似问题