×

INDEX MASKING BASED ON INSERT CONTENTION RATIO

  • US 20170091248A1
  • Filed: 12/16/2016
  • Published: 03/30/2017
  • Est. Priority Date: 04/20/2015
  • Status: Active Grant
First Claim
Patent Images

1. A computer system for reducing index insert times to improve database performance based on masking indexes above an insert contention threshold, the computer program product comprising:

  • one or more computer processors;

    one or more computer readable storage media;

    program instructions stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising;

    program instructions to receive, by one or more computer processors, settings defining a mask type for an index, wherein the index is one of a partitioned index and a data partitioned secondary index, and wherein the mask type is one of mask never, mask always, and mask automatic;

    program instructions to determine, by the one or more computer processors, that an insert contention exceeds a defined threshold;

    program instructions to determine, by the one or more computer processors, that the mask type is not mask always;

    program instructions to determine, by the one or more computer processors, that the mask type is mask automatic;

    program instructions to determine, by the one or more computer processors, that there are no active applications dependent on the index;

    program instructions to determine, by the one or more computer processors, that an index last used time does not exceed a defined threshold;

    program instructions to determine, by the one or more computer processors, that an index contention time did not exceed a defined threshold at an index access time, wherein the index contention time is defined as one of a time and a percentage of central processing unit usage;

    program instructions to determine, by the one or more computer processors, that an index key length does not exceed a defined threshold, wherein the index key length is based on the maximum size of one or more variable-length columns and the size of one or more fixed-data columns;

    program instructions to determine, by the one or more computer processors, that an index free space ratio is less than a defined threshold; and

    program instructions to mask, by the one or more computer processors, the index.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×