Query optimization technique for obtaining improved cardinality estimates using statistics on automatic summary tables
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Feb 15, 2011
Grant Date -
N/A
app pub date -
Sep 26, 2000
filing date -
Dec 22, 1999
priority date (Note) -
Expired
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 automatic summary tables 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 automatic summary tables 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