Sap Se

Sap Ag

Daniel Scheibli

Frank O Schulz

A determination is made that an execution plan for a received structure query language (SQL) database query to execute on a database is not present in a database plan cache. An external offline optimization process is triggered to generate an externally optimized execution plan for the SQL database query. The generation of the externally optimized execution plan includes: receiving all or part of the received SQL database query as SQL statements and metadata associated with the database, looping over and analyzing all the received SQL statements, selecting at least one an optimization strategy for the SQL statements; and executing the selected at least one optimization strategy to generate the externally optimized execution plan. The externally optimized execution plan is then pinned into the database plan cache.

External offline query optimization

Methods, systems, and computer product products are provided for automatically configuring hardware, such as a new computer within a computer network. To allow fast booting, a generic part of an operating system may be loaded onto the new computer. Hardware properties of the new computer may be identified using the generic part of the operating system. Further, a request may be made for the preparation of a hardware specific part of the operating system depending on the identified hardware properties of the new computer. Additionally, at least part of the hardware specific part of the operating system may be communicated between the computer network and the new computer.

Growing community of inventors

Karlsruhe, Germany

Daniel Scheibli