Why are bind variables in Toad handled different from SQL*Plus? [1 Attachment]
Johannes Ahrends <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <24532260.1410951323090893625.JavaMail.SYSTEM@alvqcfw02> |
Message from: CarajanDB I encountered a courious effect when using bind variables in simple SQL-Statements in Toad. In contrast to SQL*plus where the bind variables are marked as "BIND_SENSITIVE" the same statement is marked as not bind sensitive in Toad. As a result the explain plan is different to the one actually used in the application. I attached a short example and will be happy if someone can help or comment. _______________________________________ Historical Messages Author: Johannes Ahrends Date: Mon Dec 05 05:14:22 PST 2011 I encountered a courious effect when using bind variables in simple SQL-Statements in Toad. In contrast to SQL*plus where the bind variables are marked as "BIND_SENSITIVE" the same statement is marked as not bind sensitive in Toad. As a result the explain plan is different to the one actually used in the application. I attached a short example and will be happy if someone can help or comment. __ _______________________________________