What Is Explain Plan?

1.	What Is Explain Plan?
Answer» From the BI side, you can basically use 2 TYPES of HINTS. The Index hint instructs the optimizer to scan a specified index rather than a table. The LEADING hint forces the optimizer to build the join order of a query with a specified table. Importantly, the Explain Plan contains the following information regarding your query. Ordering of the tables referenced Access method for each table Join method for each join operation DATA operations, such as filter, sort or aggregation And in addition: Optimization (Cost and Cardinality) Partitioning Parallel Execution From the BI side, you can basically use 2 types of hints. The Index hint instructs the optimizer to scan a specified index rather than a table. The Leading hint forces the optimizer to build the join order of a query with a specified table. Importantly, the Explain Plan contains the following information regarding your query. And in addition:

Answer»

From the BI side, you can basically use 2 TYPES of HINTS.

The Index hint instructs the optimizer to scan a specified index rather than a table.

The LEADING hint forces the optimizer to build the join order of a query with a specified table.

Importantly, the Explain Plan contains the following information regarding your query.

And in addition:

From the BI side, you can basically use 2 types of hints.

The Index hint instructs the optimizer to scan a specified index rather than a table.

The Leading hint forces the optimizer to build the join order of a query with a specified table.

Importantly, the Explain Plan contains the following information regarding your query.

And in addition:

Discussion