Methods, articles of manufacture, and systems for improving the efficiency of executing queries are provided. Rather than automatically running an optimizer to determine an access plan for each issued query, an access plan may be selected from a series of access plans used for prior executions of the same or a similar query. The series of access plans used for prior queries may define a pattern that may be used to accurately predict the behavior (e.g., execution time) of a future query. For some embodiments, a query group may be established to identify a set of similar queries, for which the optimizer is likely to determine the same access plans. In response to determining an issued query fits within an established query group, an access plan associated with the query group may be selected for executing the query, thus avoiding the processing overhead of wastefully running the optimizer only to determine a previously used access plan.

 
Web www.patentalert.com

< Optimization using a multi-dimensional data model

< Method and apparatus for controlling reproduction of an audiovisual work

> System and method for locating a document containing a selected number and displaying the number as it appears in the document

> Geographic database organization that facilitates location-based advertising

~ 00255