サポートと今すぐチャット
サポートとのチャット

Spotlight on Oracle 10.5 - Release Notes

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

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択