https://community.dev.hpe.com/t5/Vertic ... a-p/235038When you submit a query to Vertica, you want it to execute as quickly and efficiently as possible. The query optimizer creates a plan that is designed to do just that. The directives in the query plan determine your query's run-time performance and resource consumption, but the properties of your projections and the system parameters also impact the query's performance.
But the query plan is just that—a plan. You really want to know what actually happened while the query executed. What projections did the query use? What system resources did the query acquire? Can adjust any parameters to make the query run faster?
Those are a lot of questions. Read on to get some answers.
Looking Under the Hood at Vertica Queries
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Looking Under the Hood at Vertica Queries
Great blog post "Looking Under the Hood at Vertica Queries" by SarahL!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.