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-07633: smsdbp: illegal protection value

1 Answers  


ORA-14053: illegal attempt to modify string in string statement

1 Answers  


QSM-01090: no query rewrite after view merging

1 Answers  


ORA-09842: soacon: Archmon unable to create named pipe.

1 Answers  


TNS-04049: Specified connections do not exist

1 Answers  


ORA-22909: exceeded maximum VARRAY limit

1 Answers  


ORA-02299: cannot validate (string.string) - duplicate keys found

2 Answers  


ORA-31185: DOM Nodes do not belong to the same DOM Document

1 Answers  


TNS-00539: Network or Protocol services are down

1 Answers  


PCC-02152: Unable to open file string to display or list the source line number

1 Answers  


ORA-00021: session attached to some other process; cannot switch session

1 Answers  


ORA-24051: cannot propagate object type payloads that have a REF attribute

1 Answers  


Categories