In this tutorial, we’ll go over query plans in Vertica.
Query Plan OverviewVertica 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 InformationYou can get information about query plans by:
- Running the EXPLAIN command
- Viewing the plan in Management Console
- Querying the QUERY_PLAN_PROFILING system table