Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Spotlight on Oracle 10.9 - 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

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation