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-33468: (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.

1 Answers  


DRG-50941: PL/SQL function string cannot be executed

1 Answers  


PCC-02115: Unable to open output file for writing

1 Answers  


TNS-00231: Pump is alive

1 Answers  


DRG-50803: failed to define output

1 Answers  


ORA-01922: CASCADE must be specified to drop 'string'

1 Answers  


ORA-01090: shutdown in progress - connection is not permitted

1 Answers  


ORA-19005: Duplicate XMLType LOB storage option

1 Answers  


ORA-00470: LGWR process terminated with error

1 Answers  


ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY

1 Answers  


ORA-24503: codepoint length overflows for piecewise operation

1 Answers  


ORA-04054: database link string does not exist

1 Answers  


Categories