This paper describes an implementation of Kruskal's algorithm in query optimization process for generation of a near optimal execution query tree. The open source PostgreSQL DBMS was used in the experiments since its query optimization is performed by Dynamic Programming and Genetic algorithm, which allows a concrete comparison with our approach. Kruskal's algorithm presents some advantages like its simplified code, its polynomial-time execution and the reduced search space to generate only one query tree, that will be the optimal tree. In most experiments, Kruskal's algorithm got the expected results in almost the same time as the results achieved by default PostgreSQL's optimization algorithms. The results confirm that Kruskal's algorithm is a feasible method for query optimization.
Citation:
Pryscila Barvik Guttoski, Marcos Sfair Sunye, Fabiano Silva, "Kruskal's Algorithm for Query Tree Optimization," ideas, pp.296-302, 11th International Database Engineering and Applications Symposium (IDEAS 2007), 2007