Databases Reference
In-Depth Information
We can see that the database will perform an FTS operation. Using the index to access
rows in the table will use more resources, because most of the data in the table satisfies
the where condition.
Execute the same query, in step 6, but ask for the least common value "A" in
CUST_VALID
field. The execution plan of the query changes, as shown in the following screenshot:
