User`s guide

PC Data
Total
Records
Read
For each A
reads in B
Reads AIndex BIndex A
Selection
Formula
Link
ing/Subre
port
2600
100
(26*100)
26YesYes or NoNoLinking
2600
100
(26*100)
26YesNoYesLinking
200100 (2*100)2YesYesYesLinking
67,600
2600
(26*2600)
26NoNoNoSubreport
67,600
2600
(26*2600)
2NoYesNoSubreport
2600
100
(26*100)
26YesYesNoSubreport
5200
2600
(2*2600)
2NoNoYesSubreport
2600
100
(26*100)
26YesNoYesSubreport
200100 (2*100)2YesYesYesSubreport
SQL Data
Total Records
Read
For each A
reads in B
Reads A
Selection Formu-
la
Linking/Subre
port
2600100 (26*100)26NoLinking
200100 (2*100)2YesLinking
2012-03-14523
Understanding Databases