Index tuner for given workload
作者： Atul Adya , Vivek R. Narasayya , Surajit Chaudhuri , Sanjay Agrawal
DOI:
关键词:
摘要: An index tuning wizard produces a fast and reasonable recommendation identifying database indexes to use given specified workload. A query optimizer is used determine the expected usefulness of potential for workload by taking cost queries in into account. based pruning then performed provide an intermediate set proposed indexes. Indexes having most benefit on storage constraints are selected. The again, further done benefits basis. not recommended unless it has significant impact
lens.org 参考文章(8)
Vivek Narasayya, Surajit Chaudhuri, Database system index selection using index configuration enumeration for a workload ,(1997)
Vivek Narasayya, Surajit Chaudhuri, Database system multi-column index selection for a workload ,(1997)
Vivek Narasayya, Surajit Chaudhuri, Database system index selection using candidate index selection for a workload ,(1997)
Vivek Narasayya, Surajit Chaudhuri, Database system index selection using cost evaluation of a workload for multiple candidate index configurations ,(1997)
Vivek R. Narasayya, Surajit Chaudhuri, An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server very large data bases. pp. 146- 155 ,(1997)
Mohamed Ziauddin, Methods for collecting query workload based statistics on column groups identified by RDBMS optimizer ,(1997)
Michael Burrows, Constrained searching of an index ,(1999)
Surajit Chaudhuri, Vivek Narasayya, AutoAdmin “what-if” index analysis utility Proceedings of the 1998 ACM SIGMOD international conference on Management of data - SIGMOD '98. ,vol. 27, pp. 367- 378 ,(1998) , 10.1145/276304.276337