FEEDBACK MECHANISM PROVIDING ROW-LEVEL FILTERING EARLIER IN A PLAN

摘要

According to present invention embodiments, methods, systems, and computer readable media of executing a database query are provided. One or more predicates are generated based on implicit filtering present within the database query, wherein each predicate specifies a condition with respect to a predicate value. An access path is selected for the database query based on the one or more predicates and the one or more predicates are integrated within the selected access plan. The database query is executed in accordance with the selected access plan. At least one predicate value based on data accessed is updated, as the database query is being executed, to increase filtering of data during remaining execution of the database query.

主权项

1. A method of executing a database query comprising:
generating one or more predicates based on implicit filtering present within the database query, wherein each predicate specifies a condition with respect to a predicate value; selecting an access path for the database query based on the one or more predicates and integrating the one or more predicates within the selected access plan; executing the database query in accordance with the selected access plan; and updating the predicate value of at least one predicate based on data accessed, as the database query is being executed, to increase filtering of data during remaining execution of the database query.