Patent ID: 6195653
Filing Date: 2001-02-27
Classification: G06F,Y10S

Abstract:
An apparatus for selectively preparing customized reports of query explain data for at least one query statement to be executed by a database, the apparatus comprising:a memory device having thereon modules of operational data and executable code for execution by a processor, the modules comprising:a plurality of report generation modules configured to selectively retrieve, from the database, subsets of the query explain data for the at least one query statement and to format the subsets for display to a user;a customization module configured to provide an interactive customization display on a display device; anda controls module configured to provide within the interactive customization display one or more controls for selectively designating subsets of the query explain data for the at least one query statement to be included in the report;wherein the report generation modules are selectively invokable by the one or more controls to include in the report the designated subsets of the query explain data for the at least one query statement.