US Patent 7634457 Function-based index tuning for queries with expressions

Patent 7634457 was granted and assigned to Oracle on December, 2009 by the United States Patent and Trademark Office.

Overview Structured Data Issues Contributors Activity

Is a

Patent

Patent attributes

Current Assignee

Oracle

Patent Jurisdiction

United States Patent and Trademark Office

Patent Number

7634457

Date of Patent

December 15, 2009

Patent Application Number

11287622

Date Filed

November 28, 2005

Patent Primary Examiner

‌

Neveen Abel Jalil

Patent abstract

Systems, methods, and media associated with function-based index tuning for queries with expressions are described. One exemplary method includes receiving a query for which an index is to be recommended. The query may include an expression, thus the method may include identifying an expression in the query and generating a set of column statistics related to the expression. The method may also include identifying candidate function-based indexes associated with the query, generating a set of function-based index statistics related to the candidate function-based indexes, and recommending a candidate function-based index.