26Dec/091
SQLPlus might show incorrect explain plan
Be careful when using SQLPlus to investigate performance problems as it might show you incorrect results in certain conditions.
Here is one example:
In the following scenario, we are trying to find out if a simple expression:
WHERE char_column = :bind
will produce different execution plans with NUMBER and CHAR binds.