Method and apparatus for viewing the effect of changes to an index for a database table on an optimization plan for a database query
作者： Edward Kosciuszko , Sreekumar Menon , Hung-Vuong Vo
DOI:
关键词:
摘要: A method and apparatus for viewing the effect of changes to an index a database table on optimization plan query, such as SQL statement. virtual is created which mimics structure original database. The by copying table, excluding any data in table. Any existing indexes associated with are copied define References query replaced references management system then determines new query.
google.de 参考文章(34)
Lam H. Thai, System and methods for optimizing database queries ,(1996)
Hong Sang Tie, Donald J. Haderle, Randy Mitchell Nakagawa, Jerry Mukai, Determining the optimal access path for a query at execution time using an actual value for each variable in a query for estimating a filter factor ,(1997)
Vivek Narasayya, Surajit Chaudhuri, Database system index selection using index configuration enumeration for a workload ,(1997)
Guy Maring Lohman, David Everett Simmen, Bruce Gilbert Lindsay, Mir Hamid Pirahesh, Monica Sachiye Urata, Eugene Jon Shekita, Star/join query optimization ,(1997)
Michael Burrows, Method for maintaining an index ,(1996)
Guy M. Lohman, John D. Palmer, Kiyoshi Ono, System for adapting query optimization effort to expected execution time ,(1992)
Eric Vachey, Method to help in optimizing a query from a relational data base management system ,(1995)
Sangam Pant, Gregory S. Smith, Database index design based upon request importance and the reuse and modification of similar existing indexes ,(1992)
Peter Lyngbaek, Ming-Chien Shan, View composition in a data base management system ,(1988)
Honesty Cheng Young, Eugene Jon Shekita, Iterative dynamic programming system for query optimization with bounded complexity ,(1994)