Apparatus and method for dynamically determining index split options from monitored database activity

摘要

The activity of a database is monitored, and index split options are dynamically determined from the monitored database activity. Appropriate action may then be taken based on the dynamically determined index split options. For example, the index may be automatically split using the dynamically determined index split options. A user command that specifies index split options may be compared to the dynamically determined index split options, and if the user command is not compatible with the dynamically determined index split options, the command may be inhibited, or the user may receive a warning message in response to the command. In addition, existing index use may be monitored, and if the monitored index use indicates the index is split poorly, the index may be re-generated using the dynamically determined index split options.