bdfd1m17 | Database Administration |
You may be able to reduce the number of file accesses by moving data from detail subfiles into the index file. Figure 46 shows a TPFDF index file with a number of detail subfiles.
The number of file accesses could be reduced considerably if the data in the subfiles were moved to the index file. Figure 47 shows the resulting single file.
Figure 47. Subfile Data Moved to Index File
The original index file contained pointers to the detail subfiles. Now that these have been removed, the pointers are no longer needed. As you can see here, they have been removed from the index file.