Profiling queries using MC

Management Console allows you to view profile data for a query.

• On the MC Home Page, click the database to view the Overview page.

• Click the Explain tab to perform tasks related to profiling a query.

See Viewing profile data in MC for further details.

On the Explain tab, you can view the following profile data using MC:

• Query phase duration
• Projection metadata
• Execution events
• Optimizer events
• Profile metrics

You can use any of the four different formats to view the profile data:

• Path Information view

• Query Drilldown view

• Tree Path view

• Profile Analysis view

See Viewing different profile outputs for detailed explanation of each view.

Additionally, Management Console supports different color codes for viewing the progress of profiling a query. For an explanation of these color codes, see Monitoring profiling progress.

See also

• Viewing profile data in MC