Previous Topic: IntroductionNext Topic: Sample RPROF Table Definition


Table Definition

The first four columns and the RPROF table column KEYFILL are used to define a unique index. When SUBPAGE equals 16, as in SUBPAGE = 16, KEYFILL causes the RPROF key to be large enough to allow one entry per SUBPAGE. The table has VARCHAR columns, but they are always filled to ensure that a record in RPROF never shares a 4K page with another RPROF record.

Note: If Type 2 Index is used, the KEYFILL field is omitted.

More information:

Sample RPROF Table Definition