HP Intelligent Management Center Standard Software Platform - Manual (Page 668)

Does your primary report include a record selection formula that sets
range limits on the key (indexed) field in Table A?
• Index A
Is Table A on the field you are going to use indexed to match up the
records?
• Index B
Is Table B on the field you are going to use indexed to match up the
records?
• Reads A
How many records does the program have to read out of Table A to find
the two records it is looking for?
• For each A reads in B
How many records does the program have to read in Table B to find the
200 records it is looking for?
• Total Records Read
What is the total number of records the program has to process to
complete the task?
PC Data
Total
Records
Read For each
A reads
in B
Reads A Index B Index A
Selec-
tion For-
mula Link
ing/Sub
report
2600
100
(26*100)
26 Yes
Yes or
No
No Linking
2600
100
(26*100)
26 Yes No Yes Linking
668 Crystal Reports 2008 SP3 User's Guide
Understanding Databases 25
Linking tables