New Uses for Directed Queries

Moderator: NorbertKrupa

Post Reply
User avatar
Site Admin
Site Admin
Posts: 1824
Joined: Sat Jan 21, 2012 4:58 am

New Uses for Directed Queries

Post by JimKnicely » Thu Jun 01, 2017 1:46 pm

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:
Jim Knicely


Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”