System, method, and computer-readable medium for automatic index creation to improve the performance of frequently executed queries in a database system
作者： Louis Burger
DOI:
关键词:
摘要: A system, method, and computer-readable medium that facilitate the optimization of frequently executed queries via automated index creation are provided. Standard optimizer strategies for dynamic utilized with query frequency information taken from a system's request cache. The described mechanisms provide process determining what indexes would be beneficial to performance based on decisions is ultimately responsible choice usage. Further, plan cache in manner provides reliable about historical anticipated specific queries.
lens.org 参考文章(12)
Harumi Kuno, Goetz Graefe, Janet L. Wiener, Query plan analysis of alternative plans using robustness mapping ,(2009)
Atul Adya, Vivek R. Narasayya, Surajit Chaudhuri, Sanjay Agrawal, Index tuner for given workload ,(2000)
Seema Sundara, Wesley Lin, Dinesh Das, Techniques for optimizing SQL statements using user-defined indexes with auxiliary properties ,(2008)
David S. Rubin, Brijesh Agarwal, Database system with methods for optimizing query performance with a buffer manager ,(1995)
Anisoara Nica, Daniel J. Farrar, Database system with methodology for automated determination and selection of optimal indexes ,(2004)
Eric Sedlar, Ravi Murthy, Nipun Agarwal, Sivasankaran Chandrasekar, Fei Ge, Cost-based optimizer for an XML data repository within a database ,(2004)
Jeetendra Chaware, Manjula Koppuravuri, Douglas P. Brown, Index selection in a database system ,(2009)
Marius Dumitru, Eric Deverne Jacobsen, Filtering of multi attribute data via on-demand indexing ,(2008)
Vivek Narasayya, Surajit Chaudhuri, Ravishankar Ramamurthy, Detecting estimation errors in dictinct page counts ,(2008)
Benoit Dageville, Mohamed Ziauddin, Dinesh Das, Yali Zhu, Hong Su, Maintaining and Utilizing SQL Execution Plan Histories ,(2008)