I got this plan for a query:

PLAN SORT (
  JOIN (
    JOIN (
      JOIN (
        BUPD NATURAL,
        UPD INDEX ("IX_PK_Uppdatering"),
        SP INDEX ("IX_Uppgiftsspärr_TilläG2M")
      ),
      E INDEX ("IX_Epostadress_UppgiftLZH")
    ),
    F NATURAL
  )
)

Would this mean that the table F would be subject to a full natural scan
for each record of the preceding joins?

Or does it mean that F is scanned once during which each F record is
matched against the result set of the joins?

F is large (well, ~3 million records) and the join result set is small
(~10000 records).

Mvh,
Kjell


[Non-text portions of this message have been removed]