Back to results
US 6,223,171 B1Granted
What-if index analysis utility for database systems
AssigneeMicrosoft Corporation
InventorsSurajit Chaudhuri, Vivek Narasayya
Life of this patent
Estimating the term…
Loading patent…
Loading patent…
AssigneeMicrosoft Corporation
InventorsSurajit Chaudhuri, Vivek Narasayya
Estimating the term…
What-if index analysis utility provides the ability to analyze the performance of the existing configuration of a database system with respect to one or more workloads of queries and to propose a hypothetical configuration for the database system to analyze its potential impact on the performance of the database system. The utility may be used, for example, to perform an impact analysis of the set of indexes selected by an index selection tool, for example, with respect to a workload of queries and may also be used to explore what-if scenarios for the database system by analyzing the impact of hypothetical sets of indexes with respect to the execution of various workloads over projected sizes of a database. The utility may be used to perform summarizations of workloads, configurations, and the performance of workloads with respect to the existing configuration and hypothetical configurations. What-if index analysis utility may be used, for example, by a database administrator or a physical database design tool to help improve performance of a database system.
In a database system that executes queries over an existing configuration defined by an existing database and an existing set of indexes, a method for analyzing the database system comprising the steps of:
The method of clam 10, wherein the index usage identifying step comprises the step of identifying the index usage of one or more queries with respect to a configuration using a query optimizer of a database server.
A computer readable medium having computer-executable instructions for analyzing a database system that executes queries over an existing configuration defined by an existing database and an existing set of indexes, the computer-executable instructions for performing steps comprising:
A method for interfacing for a database system that executes queries over an existing configuration defined by an existing database and an existing set of indexes, the method comprising the step of:
A computer readable medium having computer-executable instructions for interfacing for a database system that executes queries over an existing configuration defined by an existing database and an existing set of indexes, the computer-executable instructions for performing the step of:
A method for interfacing for a database system, the method comprising the step of:
A computer readable medium having computer-executable instructions for interfacing for a database system, the computer-executable instructions for performing the step of:
Dependencies are inferred from the claim text.