General | Explain Plan
Explain Plan
| Option | Description | ||
|---|---|---|---|
| Explain Plan Table Owner | User name of the owner of the default plan table. | ||
| Explain Plan Table | Name of the default plan table. | ||
| Table Access Full warning Threshold | The number of rows that must exist in a table before the icon in the execution plan is changed from green to red to draw your attention to the full table scan. | ||
|
Abbreviate Join Text |
Select to abbreviate the text that is displayed in the execution plan for table joins. The abbreviation feature reduces the large amount of join text associated with a large query so that you can focus on the overall steps in the execution plan. | ||
|
Explain Plan Color |
The color of the individual items in the execution plan.
|
