Optimization of queries using retrieval status of resources used thereby
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Dec 11, 2007
Grant Date -
Apr 28, 2005
app pub date -
Oct 22, 2003
filing date -
Oct 22, 2003
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
An apparatus, program product and method utilize the retrieval status of a resource to generate an access plan for a database query that uses the resource. The retrieval status, which indicates, for example, what percentage of a given resource is already stored in working memory, and thus need not be separately retrieved during query execution, may be used to generate more accurate input/output cost estimates for access plans, and thus enable a query optimizer to better select an access plan that is optimal under given runtime conditions.
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