The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jan. 13, 2015
Filed:
May. 14, 2008
Robert Joseph Bestgen, Rochester, MN (US);
Robert Victor Downer, Rochester, MN (US);
Shantan Kethireddy, Rochester, MN (US);
Robert Joseph Bestgen, Rochester, MN (US);
Robert Victor Downer, Rochester, MN (US);
Shantan Kethireddy, Rochester, MN (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A query optimizer optimizes a query to a partitioned database table by determining common characteristics of the partitions and generating a virtual maintained temporary index that spans multiple partitions. Using the virtual maintained temporary index allows the query optimizer to generate an access plan based on the virtual maintained temporary index, which relieves the optimizer from having to individually optimize access to each partition for partitions that share common characteristics.