Query optimization technique for obtaining improved cardinality estimates using statistics on pre-defined queries
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Feb 26, 2013
Grant Date -
Sep 16, 2004
app pub date -
Mar 24, 2004
filing date -
Dec 22, 1999
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A technique for optimizing execution of a query that accesses data stored on a data store connected to a computer. Statistics on one or more pre-defined queries are used to determine an optimal query execution plan for the query. In particular, improved cardinality estimates are generated for one or more query execution plans for the query using statistics of one or more pre-defined queries that vertically overlap the query. These cardinality estimates are used to make more accurate cost estimates, thus improving the likelihood of determining the optimal query execution plan.
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