Databases Reference
In-Depth Information
In step 3, we execute a simple query in order to satisfy our requirements, obtaining the
following execution plan:
We can see that the optimizer has chosen to use the
CUSTOMERS_YOB_BIX
bitmap index
(on field
CUST_YEAR_OF_BIRTH
) to access the data in the
CUSTOMERS
table.
In step 4, we execute the same query, adding a hint to the optimizer, suggesting the use of
a full table scan operation, resulting in the following execution plan:
