Method and apparatus for viewing the effect of changes to an index for a database table on an optimization plan for a database query
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
May 24, 2005
Issued Date -
N/A
app pub date -
Jul 6, 2001
filing date -
Jul 20, 1999
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A method and apparatus for viewing the effect of changes to an index for a database table on an optimization plan for a database query, such as an SQL statement. A virtual table is created which mimics the structure of an original table on the database. The virtual table is created by copying the original table, excluding any data in the original table. Any existing original indexes associated with original table are copied to define a virtual index associated with the virtual table. References in the query to the original table are replaced with references to the virtual table. The database management system then determines a new optimization plan for the query.
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