Databases Reference
In-Depth Information
In the next screenshot, you can see the execution plan for this query. Even in this case,
the operations required are a
FULL
TABLE
SCAN
and a
HASH
GROUP
BY
.
In step 5, we create an index on the
CUSTOMERS
table on the columns
CUST_CITY
,
CUST_LAST_NAME
, and
CUST_FIRST_NAME
.