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:
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.