Strategies of Finding DBMS Query Optimizer’s Plan
Authors: Postnikov V.A., Grebennikov N.A. | Published: 12.01.2015 |
Published in issue: #2(51)/2003 | |
DOI: | |
Category: Informatics & Computing Technology | |
Keywords: |
Approaches to the DBMS query optimizer’s plan construction is reviewed. Algorithms of upward and downward strategies to find an optimal plan are detailed on the set of the query optimizer’s plans. Examples of using the above strategies are given. Methods to improve the downward finding strategy algorithm are offered which allow increasing its productivity.