To view and analyze the shape of an execution plan, perform the following steps:
Execute the
EXPLAINstatement to view the shape of the execution plan, or view the cached execution plan by real-time execution plan display. For more information, see Introduction to SQL execution plans and Real-time execution plan display.Analyze the shape of the execution plan to determine whether the selection of the index, join order, and join algorithm is reasonable and correct. For more information, see Access path, Join order, and Join algorithms.