The page size is used by the system to determine the size of each page of the index. This page size is the amount of bytes of the index that can be moved into the job's storage pool from the auxiliary storage for a page fault.
Possible values are:
Default - page size will be determined by the total length of the key, or keys.
8 KB
16 KB
32 KB
64 KB
128 KB
256 KB
512 KB
Use a larger page size if the indexes are primarily used for complex queries or queries that need to inspect a large number of index keys. Use a smaller page size for random look up operations. For example, searching for a specific customer number.