LMV_JOIN_OPTIMIZATION_RESULTS
This view contains information about the results of join optimization operations. This table displays rows for each query plan and each table joined in the query plan.
Column Name | Description |
|---|---|
| The activity name of the query plan. This corresponds to |
| The text of the query. |
| The name of the related database. |
| The name of a table within a given join. |
| Whether or not a given join is local. |
| The sequence number of this row among the rows for this query plan. |
| The number of tables included in a given join. |
| The position of the table in its join. |
| The estimated fraction of rows that satisfy the filter conditions on a given table (not including conditions involving multiple tables, i.e. join conditions) |
| The estimated fraction of rows that satisfy the join conditions. |
| The estimated rowcount of the table. |
| The estimated rowcount of the table after filter conditions on this table only. |
| The estimated rowcount of the join so far after joining this table. |
| The estimated cost of executing a given join so far, according to the optimizer’s cost model. |