Understanding Query Plans

In this tutorial, we’ll go over query plans in Vertica.

Query Plan Overview

Vertica can execute a query in many different ways to achieve the same results. When you submit a query to Vertica, the query optimizer evaluates the possible sequence of step-like paths it can take. These path options are called query plans. The query optimizer analyzes different options and returns what it considers to be the best alternative, which is usually a query plan with the lowest cost.

How to Get Query Plan Information

You can get information about query plans by:
  • Running the EXPLAIN command
  • Viewing the plan in Management Console
  • Querying the QUERY_PLAN_PROFILING system table
For more information, see Query Plan Information and Structure in the Vertica documentation.

Learn More

To learn more about query plans in Vertica, see our documentation.