×

STATIC DATA CACHING FOR QUERIES WITH A CLAUSE THAT REQUIRES MULTIPLE ITERATIONS TO EXECUTE

  • US 20170116271A1
  • Filed: 09/16/2016
  • Published: 04/27/2017
  • Est. Priority Date: 10/23/2015
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • receiving a query with a clause that requires multiple iterations to execute;

    prior to executing the query, determining, based on the query, one or more database operations that are;

    performed in more than one iteration, andat least partially performed against a static set of rows, said static set of rows being static during execution of the query;

    while executing the query,loading said static set of rows into a database buffer cache; and

    performing at least one iteration other than a first iteration against the buffered static set of rows.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×