Sequential scan
A sequential scan reads blocks sequentially rather than hierarchically.
The Index Build function reads blocks, identifies segments, and extracts the data necessary to build an index. Because the Index Build function is not reading the database in hierarchical order, the scan can complete significantly faster than a traditional hierarchical scan.
A sequential scan has the following requirements:
- If any concatenated key information (such as /CK) is used in fields (such as SUBSEQ, DDATA), the source segment must be the root segment.
- If the source segment is not the target segment, the target must be the parent of the source and the source must have physical parent (PP) pointers to the target.
- For HALDBs, the root segment must be the target segment.
- If the index has symbolic pointers, the source segment must be the root segment.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*