A system and method for enabling a second database instance to more quickly process
a request to execute a database statement that has previously been executed by
a first database instance is described. In one embodiment, the method involves
sending the database statement from the first database instance to the second database
instance, and generating by the second database instance one or more structures
needed to prepare the statement for execution, such as a parse tree and an execution
plan for the statement. If at some point in the future, the second database instance
receives a request to execute the same statement, the above structures can be used
for execution, thereby eliminating the need for one or more potentially time-consuming
operations, such as generation of a parse tree or execution plan for the statement.
