DBD

Discussion List

• 
  Vertica 11 Why didn't optimizer chose new DBD projection?

  Answered Pacocha 14.5K views 4 comments 0 points Most recent by Pacocha May 2022General Discussion
• 
  Cannot proceed from deploying the design

  Answered ✓ yamakawa 11.2K views 3 comments 0 points Most recent by SruthiA January 2022General Discussion
• 
  DBD supporting LAPs?

  Answered DreaBrandford 5.2K views 1 comment 0 points Most recent by ybei April 2020General Discussion
• 
  Should we still run DBD on the main cluster ?

  Answered MichaelJK 5.2K views 1 comment 0 points Most recent by ybei April 2020General Discussion
• 
  DBD recommendations based on amount of data?

  Answered DreaBrandford 8.5K views 2 comments 0 points Most recent by Jim_Knicely April 2020General Discussion
• 
  What happens if the supplied query file only uses 10 tables of 100 in a schema?

  Answered MichaelJK 5.2K views 1 comment 0 points Most recent by JoeGonzalezVertDBA April 2020General Discussion
• 
  Vertica tip: are your columns too wide?

  Bryan_H 4.3K views 1 comment -1 point Most recent by Anonymous_Wombat April 2020Tips from the Team
• 
  Can DBD use histograms from existing projections?

  Question MichaelJK 2K views 0 comments 1 point Most recent by MichaelJK April 2020General Discussion
• 
  Can DBD evaluate candidate projections against older projections?

  Question MichaelJK 2K views 0 comments 1 point Most recent by MichaelJK April 2020General Discussion
• 
  Does DBD still takes inputs (running queries) from DC tables?

  Question MichaelJK 2K views 0 comments 1 point Most recent by MichaelJK April 2020General Discussion
• 
  Does new API designer_single_run take a table name as an argument?

  Question MichaelJK 2K views 0 comments 1 point Most recent by MichaelJK April 2020General Discussion
• 
  Will DBD fully support newest features like LAPs, flatten tables and complex data types?

  Question MichaelJK 2K views 0 comments 1 point Most recent by MichaelJK April 2020General Discussion
• 
  How should we provision the DBD resouce pool for an effective design?

  Question MichaelJK 2K views 0 comments 1 point Most recent by MichaelJK April 2020General Discussion
• 
  Can you drop a table with DBD-generated projections without using CASCADE?

  Question MichaelJK 2K views 0 comments 1 point Most recent by MichaelJK April 2020General Discussion
• 
  DBD: Selecting a table vs. schema to optimize

  Answered DreaBrandford 5.3K views 1 comment 0 points Most recent by Jan_Soubusta April 2020General Discussion
• 
  DBD and identical buddy projections

  Answered DreaBrandford 5.2K views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  How many projections used per query?

  Answered DreaBrandford 8.6K views 2 comments 0 points Most recent by DaveT April 2020General Discussion
• 
  DBD: How many candidate projections?

  Answered DreaBrandford 5.2K views 1 comment 0 points Most recent by RaghavAg April 2020General Discussion
• 
  DBD: Can we see the benefit/cost scores for projection candidates?

  Question DreaBrandford 2K views 0 comments 1 point Most recent by DreaBrandford April 2020General Discussion
• 
  How does DBD calculate storage?

  Question DreaBrandford 2.1K views 0 comments 1 point Most recent by DreaBrandford April 2020General Discussion
• 
  DBD enhancement: supporting views

  Question DreaBrandford 2K views 0 comments 1 point Most recent by DreaBrandford April 2020General Discussion