Function-based index tuning for queries with expressions
作者： Shilpa S. Lawande
DOI:
关键词:
摘要: Systems, methods, and media associated with function-based index tuning for queries expressions are described. One exemplary method includes receiving a query which an is to be recommended. The may include expression, thus the identifying expression in generating set of column statistics related expression. also candidate indexes query, indexes, recommending index.
google.de 参考文章(12)
Deborah Jing-Hwa Hwang, Function-based indexing for object-oriented databases Massachusetts Institute of Technology. ,(1994)
Mohamed Zait, Khaled Yagoub, Benoit Dageville, Mohamed Ziauddin, Leng Leng Tan, Karl Dias, Dinesh Das, Mark Ramacher, Automatic SQL tuning advisor ,(2004)
Adiel Yoaz, Robert J. Jenkins, Automatic use of a functional index as a primary filter ,(2004)
Vivek Narasayya, Surajit Chaudhuri, Database system index selection using candidate index selection for a workload ,(1997)
Daniel S. Lipkin, Method and apparatus for an information server ,(2001)
John R. Ripley, Similarity search engine for use with relational databases ,(2003)
Srinivas Panuganti, Robert S. Larson, Daniel S. Lipkin, Christopher S. Helgeson, Method and apparatus for managing data exchange among systems in a network ,(2001)
Surajit Chaudhuri, An overview of query optimization in relational systems symposium on principles of database systems. pp. 34- 43 ,(1998) , 10.1145/275487.275492
Jeetendra Chaware, Manjula Koppuravuri, Douglas P. Brown, Index selection in a database system ,(2009)
Guy M. Lohman, Gary Valentin, Method for determining optimal database materializations using a query optimizer ,(1998)