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..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24007: invalid value string, MAX_RETRIES should be non-negative integer

1 Answers  


DRG-12225: this type of section cannot be added to this section group

1 Answers  


ORA-26514: object 'string.string' not found

1 Answers  


ORA-09777: osnpbr: cannot send break message

1 Answers  


ORA-01525: error in renaming data files

1 Answers  






PLS-00620: type mismatch found at 'string' among operands in a COALESCE expression

1 Answers  


PLS-00394: wrong number of values in the INTO list of a FETCH statement

1 Answers   CSC,


ORA-24410: scrollable cursor max size exceeded

1 Answers  


ORA-08267: destroy_ora_addr: cannot close nameserver

1 Answers  


NZE-28844: No wallet present

1 Answers  


LPX-00279: invalid no_proxy "~s"

1 Answers  


DRG-10550: illegal syntax for index, preference, source or section name

1 Answers  


Categories