Automatically determining data that is best suited for index tuning
AssigneeOracle Corporation
InventorsTodd Guay, Gregory Smith, Gaylen Royal, Cheryl Mrozienski
Life of this patent
Estimating the term…
Abstract
An approach for automatically determining database tables that are best suited for index tuning involves analyzing query performance data that specifies an average amount of time required to execute a plurality of queries on the database tables. One or more particular queries are selected from the plurality of queries based upon the query performance data. Data tables required to process the one or more particular queries are selected for index tuning.
Claims28
A method for automatically determining, from a plurality of bodies of data, which bodies of data are being accessed inefficiently, relative to other bodies of data from the plurality of bodies of data, the method comprising the computer implemented steps of:
- examining query performance data that indicates performance of a plurality of queries that access the plurality of bodies of data;
- and
- selecting, based upon both the query performance data and a set of one or more candidate selection factors, particular bodies of data from the plurality of bodies of data that are being accessed inefficiently relative to other bodies of data from the plurality of bodies of data.
A method for performing index tuning on particular tables from a plurality of tables in a database system, the method comprising the computer-implemented steps of:
- selecting particular queries from a plurality of queries based upon the performance of the plurality of queries;
- identifying a set of one or more tables accessed during the execution of the particular queries;
- selecting particular tables from the set of one or more tables based upon table selection criteria;
- and
- performing index tuning on the particular tables.
A computer-readable medium carrying one or more sequences of one or more instructions for automatically determining, from a plurality of bodies of data, which bodies of data are being accessed inefficiently, relative to other bodies of data from the plurality of bodies of data, the one or more sequences of one or more instructions including instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of:
- examining query performance data that indicates performance of a plurality of queries that access the plurality of bodies of data;
- and
- selecting, based upon both the query performance data and a set of one or more candidate selection factors, particular bodies of data from the plurality of bodies of data that are being accessed inefficiently relative to other bodies of data from the plurality of bodies of data.
A computer system for automatically determining, from a plurality of bodies of data, which bodies of data are being accessed inefficiently, relative to other bodies of data from the plurality of bodies of data, the computer system comprising:
- one or more processors;
- and
- a memory coupled to the one or more processors and containing one or more sequences of one or more instructions which, when executed by the one or more processors, cause the one or more processors to perform the steps of:
- examining query performance data that indicates performance of a plurality of queries that access the plurality of bodies of data;
- and
- selecting, based upon both the query performance data and a set of one or more candidate selection factors, particular bodies of data from the plurality of bodies of data that are being accessed inefficiently relative to other bodies of data from the plurality of bodies of data.
Dependencies are inferred from the claim text.