Databases Reference
In-Depth Information
In step 10, we change the parameter value to 1 and execute the same query again. In the
following screenshot, we can see the output of this query:
We can see that the execution plan hasn't changed, so we are accessing the table using the
X1_MY_TEST
index. This is not the fastest execution plan for this query, because we know
that there are more than 50000 rows in the table (more than 99.99 percent of the total rows)
that satisfy the query predicate; a full table scan is more efficient in such situations.
In step 11 and step 12, we execute the same queries as in step 9 and step 10, but without
using the bind variable. When we query for value 2, we obtain the following execution plan
that uses the same index as before:
