Search notes:

Oracle SQL Plan operation INDEX RANGE SCAN (MIN/MAX)

The parent operation of INDEX RANGE SCAN (MIN/MAX) is always a FIRST ROW.
INDEX RANGE SCAN (MIN/MAX) has no child row source.

See also

INDEX FULL SCAN (MIN/MAX)
Plan operations

Index