Tools

The System Explorer, SQL, Tools drop-down list provides access to the following tools. These are the same tools available from System Explorer, Tools, SQL Performance Tools:

SQL Runtime Statistics: user interface to generate SQL Runtime Statistics for a specified query.
Index Analyzer: user interface for gathering various types of index analysis for a specified schema.
Alternative Show Plans: user interface to generate Alternate Show Plans for a specified query.
Generate Report to submit an SQL query performance report to InterSystems WRC (Worldwide Response Center customer support). To use this reporting tool you must first get a WRC tracking number from the WRC.
Import Report to import an existing WRC report by file name. For InterSystems use only.

SQL Process View

Open Table