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]
