Access path selection for SQL with variables in a RDBMS
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Apr 17, 2001
Grant Date -
N/A
app pub date -
Sep 8, 1999
filing date -
Sep 30, 1997
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A method, apparatus, and article of manufacture for a computer implemented query compiler. A query is executed in a computer, the query being performed by the computer to retrieve data from a database stored on a data storage device connected to the computer. The query is received containing at least one variable. At execution time, a value is determined for each variable in the query. A filter factor is estimated using the determined value for each variable. Then, an access path is determined for the query using the estimated filter factor.
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