摘要 |
There is provided a system and method for performing testing on a database system comprising a query optimizer, the query optimizer having an optimizer plan space comprising a plurality of query plans. An exemplary method comprises generating a plurality of queries programmatically according to a template query by varying at least one of an operation, a predicate or a parameter to produce a plurality of query plans. The exemplary method also comprises optimizing the plurality of queries using the query optimizer to collect the plurality of query plans and selecting a subset of queries from the plurality of queries using the query optimizer, the subset of queries comprising queries with distinct query plans that substantially cover the optimizer plan space. The exemplary method additionally comprises executing the subset of queries on the database system to identify an inefficiency of the database system.
|