摘要 |
A tool and method for integrating manual instructions of a database query plan with a database optimizer. The tool may be in the form of an editor to receive manual instructions associated with selection of database objects such as tables and operations associated with the objects. The editor may consult with the database optimizer prior to submitting query plan execution instructions. The consultation may result in the optimizer providing alternatively available selections to the editor and/or a cost estimate for selected operations and/or automatic selection of operators to complete a plan that has been partially constructed or edited manually. Following completion of the query plan, the editor may submit the query plan to the optimizer for execution and/or save the plan for use in future execution(s) of the query.
|