Intermediate SQL Color Coded SQL, UNIX and Database Essays

26Dec/092

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.