Function-based index tuning for queries with expressions
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Dec 15, 2009
Grant Date -
Apr 12, 2007
app pub date -
Nov 28, 2005
filing date -
Oct 7, 2005
priority date (Note) -
In Force
status (Latency Note)
Importance
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.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully