Select all that apply.

• A

  The optimizer always uses the smaller of the two row sources to build a hash table on the join key.

• B

  It returns rows for SQL statements that contain an equijoin.

• C

  It is a non-equijoin in which the key values in one data set must fall within the specified range of the second data set.

• D

  For each row in the first row source, Oracle probes the second row source for matching rows and joins them.

• E

  The SQL runtime engine avoids unnecessary scanning of rows that fall outside the defined ranges.