HP 3000 Manuals HP 3000 Manuals
Lesson 4: Quiz 6
1. What is the default access sequence and method?
The default access sequence is the order of the source
tables on the Define Table screen, and the default access
method is serial read.
2. Is it necessary to know about Image databases/KSAM files: (a)
Before using BRW? (b) Before tuning BRW reports?
a. No. By default, BRW considers each data set, file or KSAM
file to be a serial file of records.
b. Of course, when tuning reports using databases and KSAM
files it is better to understand the most efficient ways of
retrieving records; so one must understand keys and keyed
access.
3. Where could you find out when BRW makes a data selection?
From the compile listing, under T A B L E C A L C U L A T
I O N S A N D S E L E C T I O N.
4. Where could you find out how much time a report took to run?
From the execution listing, under cpu-sec and elapsed-sec.
5. From the listings: (a) What is the approximate difference in cpu
time between lessons 2 and 3? (b) What is the approximate
difference in elapsed time between the two tasks?
a. 0.525 seconds (Report 3 is approximately 26% faster.)
b. 1.32 seconds (Report 3 is approximately 27% faster.)