System and method for filtering query statements from multiple plans and packages according to user-defined filters of query explain data

摘要

An apparatus for filtering a plurality of groups of query statements according to identification data associated therewith includes a processor for executing instructions and a memory device having thereon modules of operational data and executable code for execution by the processor. The modules include at least one filtering module configured to receive one or more user-specified filtering criteria directed to a subset of the identification data and apply the filtering criteria to selectively exclude those of the plurality of groups not satisfying the filtering criteria. The modules also include a group listing module configured to display to a user those of the plurality of groups not excluded by the at least one filtering module.