If you create an index in batch mode, re-create an index, reorganize an index, or reorganize data using the rebalancing utility, you need the following size of work table file:
Size of a work table file used by a utility (bytes) = {A + B} ![]() ![]() ![]() |
To obtain the number of rows in the work table required for index creation 1, use the following formula:
Number of rows in work table 1 = ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
To obtain the number of rows in the work table required for index creation 2, use the following formula:
Number of rows in work table 2 = ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
To obtain the number of rows per work table page, use the following formula:
Number of rows per work table page = MIN{ ![]() ![]() ![]() |
To obtain the page length of a work table, use the following formula:
Page length of work table = MIN{ ![]() ![]() ![]() ![]() |