×

Preserving a query plan cache

  • US 7,831,569 B2
  • Filed: 10/10/2007
  • Issued: 11/09/2010
  • Est. Priority Date: 10/10/2007
  • Status: Expired due to Fees
First Claim
Patent Images

1. A method for preserving a query plan cache, the method comprising, in a backup system having a dataspace containing a copy of data and a copy of a query plan cache from a production system:

  • initiating an update of at least a portion of the copy of the data on the backup system with a portion of the data on the production system;

    initiating a merge of updated query plans in the query plan cache from the production system with corresponding query plans in the copy of the query plan cache on the backup system;

    correlating objects in the updated query plans in the copy of the query plan cache with the updated copy of the data on the backup system; and

    performing statistics collection on the backup system for the updated plans in the copy of the query plan cache.

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