Using EXPLAIN {query} returns the query execution plan strategy. To get the most granular output of the query execution plan, use EXPLAIN LOCAL VERBOSE. This is useful when trying to identify partition pruning, for example.

Index Tool

These index tools can be used to check for database corruption or make validation checks after major upgrades.

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.


This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.