Databases Reference
In-Depth Information
The same execution plan is used by the database if we execute a query that retrieves
both the
MIN
and
MAX
values for the
CUST_CREDIT_LIMIT
field in step 3, as shown in
the next screenshot:
In step 4, we create an index on the field (
CUST_CREDIT_LIMIT
) where we execute the
aggregate function. This allows us to use the index instead of the full table scan operation,
resulting in a very fast execution of the query. The corresponding execution plan is as shown
in the following screenshot: