首页>
外国专利>
SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR AUTOMATIC INDEX CREATION TO IMPROVE THE PERFORMANCE OF FREQUENTLY EXECUTED QUERIES IN A DATABASE SYSTEM
SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR AUTOMATIC INDEX CREATION TO IMPROVE THE PERFORMANCE OF FREQUENTLY EXECUTED QUERIES IN A DATABASE SYSTEM
展开▼
机译:用于自动创建索引以提高数据库系统中频率执行查询的性能的系统,方法和计算机可读介质
展开▼
页面导航
摘要
著录项
相似文献
摘要
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 index creation are utilized with query frequency information taken from a system's request cache. The described mechanisms provide a process of determining what indexes would be beneficial to query performance based on decisions and information from the optimizer that is ultimately responsible for the choice of index usage. Further, the plan cache is utilized in a manner that provides reliable information about the historical and anticipated frequency of specific queries.
展开▼