Selecting From OR-Expansion States Of A Query

摘要

Methods, stored instructions, and computer systems are described for selecting an OR-expansion state of a query. A query processor accesses a certain query and a control parameter. The certain query comprises disjunctive predicates, and the control parameter indicates a certain procedure of a plurality of alternative stored procedures for expanding queries comprising disjunctive predicates into semantically equivalent candidate queries comprising combinations of subqueries. Based at least in part on the control parameter, the query processor selects the certain procedure to expand the certain query into one or more certain semantically equivalent candidate queries, each comprising a different combination of two or more subqueries. The query processor causes cost-based evaluation of subject queries, including the certain query and the one or more certain semantically equivalent candidate queries. The query processor then selects a query of the subject queries for execution or for further evaluation or transformation.

主权项

1. A method comprising:
accessing a certain query and a control parameter, wherein the certain query comprises two or more certain disjunctive predicates, and wherein the control parameter indicates a certain procedure of a plurality of alternative stored procedures for expanding queries comprising disjunctive predicates into semantically equivalent candidate queries comprising combinations of subqueries; based at least in part on the control parameter, selecting the certain procedure to expand the certain query into one or more certain semantically equivalent candidate queries, wherein each of the one or more certain semantically equivalent candidate queries, if executed, would collect results from a different combination of two or more subqueries; causing evaluation of the certain query and each of the one or more certain semantically equivalent candidate queries, and, based at least in part on the evaluation, selecting a particular query of the one or more certain semantically equivalent candidate queries or the certain query; causing execution of a transformed query that is based at least in part on the particular query; wherein the method is performed by one or more computing devices.