Database system index selection using candidate index selection for a workload
作者： Vivek Narasayya , Surajit Chaudhuri
DOI:
关键词:
摘要: An index selection tool helps reduce costs in time and memory selecting an configuration or set of indexes for use by a database server accessing accordance with workload queries. The attempts to the number be considered, configurations enumerated, invocations query optimizer workload.
lens.org 参考文章(21)
S.C. Chang, R.S. Choenni, Henk Blanken, A framework for a tool for physical database design Proceedings 3rd Ingres Benelux Users Conference. pp. 96- 107 ,(1992)
Shaibal Roy, Database system with improved methods for B-tree maintenance ,(1995)
Martin R. Frank, Edward R. Omiecinski, Shamkant B. Navathe, Adaptive and Automated Index Selection in RDBMS extending database technology. pp. 277- 292 ,(1992) , 10.1007/BFB0032437
Dennis Shasha, Steve Rozen, A Framework for Automating Physical Database Design very large data bases. pp. 401- 411 ,(1991)
Frank Olken, Doron Rotem, Simple Random Sampling from Relational Databases very large data bases. pp. 160- 169 ,(1986)
Kyuseok Shim, Surajit Chaudhuri, Method and apparatus for query optimization in a relational database system having foreign functions ,(1993)
Peter Corrigan, Mark Gurry, ORACLE Performance Tuning ,(1993)
Brijesh Agarwal, Database system with methods for improving query performance with cache optimization strategies ,(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)
Michael Hammer, Arvola Chan, Index selection in a self-adaptive data base management system Proceedings of the 1976 ACM SIGMOD international conference on Management of data - SIGMOD '76. pp. 1- 8 ,(1976) , 10.1145/509383.509385