Invention Grant
US09582409B2 Regression testing of SQL execution plans for SQL statements 有权
SQL语句的SQL执行计划的回归测试

Regression testing of SQL execution plans for SQL statements
Abstract:
A first execution plan for a first version of a structured query language statement can be requested from a database management system. The first execution plan for the first version of the structured query language statement can be loaded into a first directed graph tree structure comprising a plurality of nodes. The first directed graph tree structure can be scanned to determine whether a full table scan for accessing requested data is represented by at least a one of the plurality of nodes of the directed graph tree structure. Responsive to determining that the full table scan for accessing the requested data is represented by the at least one of the plurality of nodes of the directed graph tree structure, a first indicator that indicates a fault condition can be output.
Public/Granted literature
Information query
Patent Agency Ranking
0/0