Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

PLW-07204

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

Cause

The evaluation of the WHERE clause in this SQL statement will convert this column value to a different data type. This may prevent the SQL optimizer from using an index that includes this column and slow down the execution of the statement.


Action

Modify the operands in the expression that includes this column to avoid the data type conversion.