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-30339: illegal dimension attribute name

1 Answers  


PLS-00584: size of an opaque type must be between 1 and 4000 bytes

1 Answers  


TNS-04046: Invalid specification for source

1 Answers  


ORA-14297: Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

1 Answers  


ORA-30005: missing or invalid WAIT interval

1 Answers  


ORA-07550: sftopn: $CONNECT failure

1 Answers  


RMAN-06092: error while looking up backup piece

1 Answers  


ORA-07657: slsprom:$ASSIGN failure

1 Answers  


IMG-02001: 2FF01 - incorrect image format

1 Answers  


ORA-24850: failed to startup shared subsystem

1 Answers  


ORA-27490: cannot open disabled window "string.string"

1 Answers  


ORA-19590: conversation already active

1 Answers  


Categories