Memory structure and method for tuning a database statement using a join-tree data structure representation, including selectivity factors, of a master table and detail table
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Jun 2, 1998
Grant Date -
N/A
app pub date -
Jun 5, 1996
filing date -
Jun 5, 1996
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A method of constructing an aid to tuning of database statements comprises a data structure (stored in a memory on a computer system) which compactly represents that information which is needed about a database statement to determine the optimal series of operations (e.g., table data fetches) needed to execute the statement. The information includes the relationships between tables joined in the statement and the selectivities of logical conditions applied to rows in those tables.
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