Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-01104: number of controlfiles (string) does not equal string

1 Answers  


DRG-10834: upper-case form of section name string too long

1 Answers  


DRG-10836: field section and attribute section can not be nested

1 Answers  


ORA-08185: Flashback not supported for user SYS

1 Answers  


DRG-12433: load of string JDBC driver class failed

1 Answers  


EXP-00071: QUERY parameter not compatible with Direct Path export

1 Answers  


ORA-24026: operation failed, queue string.string has errors

1 Answers  


ORA-00314: log string of thread string, expected sequence# string doesn't match string

1 Answers  


ORA-13800: concurrent DDL failure on SQL repository objects

1 Answers  


ORA-23339: duplicate conflict resolution information

1 Answers  


SQL*Loader-00640: Variable length field was truncated.

1 Answers  


ORA-28579: network error during callback from external procedure agent

1 Answers  


Categories