This post covers how you can use the PL/SQL package DBMS_XPLAN to display execution plan information. If you want to learn more about DBMS_XPLAN options,…
View More How do I display and read the execution plans for a SQL statement
Tag: bind variables
PostgreSQL “bind variable peeking”
custom vs. generic plans With my Oracle database background, I know how important it is to balance the pros and cons of using bind variables…
View More PostgreSQL “bind variable peeking”
Adaptive Cursor Sharing in Oracle Database 11g Release 1
DBAs are always encouraging developers to use bind variables, but when bind variables are used against columns containing skewed data they sometimes lead to less…
View More Adaptive Cursor Sharing in Oracle Database 11g Release 1