Page 1 of 1

New Uses for Directed Queries

Posted: Thu Jun 01, 2017 1:46 pm
by JimKnicely
Cool Vertica Blog post "New Uses for Directed Queries" by Soniya!

Directed queries were introduced in Vertica 7.2. Directed queries were originally designed to achieve two goals:
  • Preserve current query plans before a scheduled upgrade.
  • Enable you to create query plans that improve optimizer performance.
Since their introduction, users have found new and compelling ways to use directed queries—notably, using them to substitute one query for another. The following discussion focuses on one way you might leverage this capability.

Read more here: