主权项 |
1. A method for database large object (LOB) reorganization, comprising:
calculating, by a computer, an activity of an inline LOB, wherein the activity of the inline LOB is calculated by dividing an inline LOB hit counter, which is a number of times that the inline LOB has been accessed during a time period, by a data row hit counter, which is calculated using the number of times a data row of the inline LOB has been accessed over the period of time, or a data page hit counter, which is calculated using the number of times a data page of the inline LOB has been accessed over the period of time; redefining a length of the inline LOB according to the activity of the inline LOB by determining whether the activity of the inline LOB exceeds a predetermined threshold and in response to determining that the activity of the inline LOB does not exceed the predetermined threshold, redefining the length of the inline LOB as zero; based on determining that the length of the inline LOB has been redefined to zero:
storing the inline LOB in a separate LOB table space; andinserting an indicator corresponding to the inline LOB at an original position of the inline LOB, wherein the indicator points to a position of the inline LOB in the separate LOB table space; and performing LOB reorganization based on the redefined length of the inline LOB. |