Databases Reference
In-Depth Information
In step 7, we get the histogram values from the data dictionary, as shown in the following
screenshot:
In the steps that follow, we execute the same query over the
MY_TEST
table, verifying the
execution plan when we change the
ID
value, for which we are querying, from 2 (only one
record present in the table) to 1 (more than 50000 records).
In step 8, we define a bind variable, and in step 9, we set its value to 2. The corresponding
execution plan, shown in the following screenshot, uses the index on the
ID
field, resulting
in a quicker execution time: