Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-19619: cannot call restoreValidate after files have been named

1 Answers  


ORA-03274: both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified

1 Answers  


ORA-14619: resulting List subpartition(s) must contain at least 1 value

1 Answers  


ORA-31086: insufficient privileges to register global schema "string"

1 Answers  


PLS-00109: unknown exception name 'string' in PRAGMA EXCEPTION_INIT

1 Answers  






ORA-22324: altered type has compilation errors

1 Answers  


RMAN-06053: unable to perform media recovery because of missing log

1 Answers  


ORA-13854: Tracing for service(module/action) string on instance string is not enabled

1 Answers  


ORA-32156: Cannot perform operation on stream

1 Answers  


NNL-01006: META VIOLATION responses received: number

1 Answers  


ORA-27075: SSTMOFRC constant too large

1 Answers  


ORA-33048: (XSAGDNGL23) In AGGMAP workspace object, the relation workspace object and the relation workspace object are both over the same base dimension.

1 Answers  






Categories