Chat now with support
Chat mit Support

Spotlight on Oracle 10.4 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Explain Plan Page

The table on the Explain Plan page of the Top Sessions drilldown displays the current results for the SELECT statement running during the selected session.

To open the Explain Plan page

  1. Select the Spotlight on MySQL connection in the Spotlight Browser.
  2. Click Top Sessions Page.

  3. Select a row in the Top Sessions grid.
  4. Click Explain Plan.

Grid

Column Description

ID

The ID that identifies the specified SELECT statement.

Select Type

The type of SELECT statement executed.

Table

The table to which the SELECT statement applies.

Type

The join type for the SELECT statement.

Possible Keys

The keys (indexes) that MySQL can use for the SELECT statement.

Key

The key that MySQL did use for the SELECT statement.

Key Length

The length of the key that MySQL used.

Ref

The columns or constants used with the chosen key.

Rows

The number of table rows that MySQL may examine to execute the query.

 

Related Topics

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen