发明名称 |
Method and system for transparently caching and reusing query execution plans efficiently |
摘要 |
A method and system for transparently caching and reusing database query execution plans. The method and system include caching a first query that contains a first constant. A first query is associated with an execution plan that represent the first constant with a parameter name. The method and system further include receiving a new query that contains a second constant and comparing the new query with the first query. A match is determined to exist even when the second constant fails to match the first constant. Upon a match, the first query execution plan is reused by substituting the parameter name in the query execution plan with the second constant from the new query, thereby avoiding generating a new query
|
申请公布号 |
US6466931(B1) |
申请公布日期 |
2002.10.15 |
申请号 |
US19990364755 |
申请日期 |
1999.07.30 |
申请人 |
INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
ATTALURI GOPI KRISHNA;WISNESKI DAVID JOSEPH |
分类号 |
G06F17/30;(IPC1-7):G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|