Query

Discussion List

• 
  Best practices and tips for tuning analytical functions?

  Answered rjs_docs 4.3K views 1 comment 0 points Most recent by baron42bba April 2020General Discussion
• 
  Best practices when combining multiple fact tables?

  Answered rjs_docs 4.2K views 1 comment 0 points Most recent by baron42bba April 2020General Discussion
• 
  What are some guidelines for measuring query performance for my environment?

  Answered rjs_docs 4.2K views 1 comment 0 points Most recent by [Deleted User] April 2020General Discussion
• 
  Memory usage and joins

  Answered kxu 4.2K views 1 comment 0 points Most recent by [Deleted User] April 2020General Discussion
• 
  Is it possible to filter user queries based on cost?

  Answered GaryG 4.2K views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  How does a projection's ORDER BY clause impact performance?

  Answered rjs_docs 4.5K views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Can I run an EXPLAIN query plan that rejects the query plan based on the returned Cost?

  Answered rjs_docs 4.3K views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Optimizing a query with several joins

  Answered kxu 4.3K views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Monitoring memory usage

  Answered kxu 4.7K views 1 comment 0 points Most recent by Vertica_Curtis April 2020General Discussion
• 
  Ways to minimize S3 fetches and without affecting performance?

  Answered kxu 4.2K views 1 comment 0 points Most recent by s_crossman April 2020General Discussion
• 
  Does an unused resource pool reserve memory?

  Answered rjs_docs 4.2K views 1 comment 0 points Most recent by Pan April 2020General Discussion
• 
  Keeping up-to-date statistics on tables at scale

  Question kxu 1.7K views 0 comments 0 points Started by kxu April 2020 General Discussion
• 
  Right-hand inserts and optimizer reports

  Question kxu 1.7K views 0 comments 0 points Started by kxu April 2020 General Discussion
• 
  Viewing cluster activity during a global catalog lock

  Question kxu 1.8K views 0 comments 0 points Started by kxu April 2020 General Discussion
• 
  Analyzing a constantly-loaded table

  Question kxu 1.7K views 0 comments 0 points Started by kxu April 2020 General Discussion
• 
  Updating table statistics?

  Answered rjs_docs 4.8K views 1 comment 0 points Most recent by Jim_Knicely April 2020General Discussion
• 
  Query dropped when node goes down

  Answered Min_Yun_Chan 4.2K views 1 comment 0 points Most recent by ybei April 2020General Discussion
• 
  incorrect vertica projection selection

  Answered rajatpaliwal86 4.3K views 1 comment 0 points Most recent by ChuckB March 2020General Discussion
• 
  How do I handle the password in vsql command in crontab?

  Answered Prairiedog 10K views 3 comments 0 points Most recent by ChuckB March 2020General Discussion
• 
  Joins on multiple(more than two) tables - extremely slow

  Answered rajatpaliwal86 25.9K views 9 comments 0 points Most recent by rajatpaliwal86 December 2019Product Feedback
• 
  Only one user took same query longer

  Answered rezakomo 16.9K views 6 comments 0 points Most recent by Jim_Knicely December 2019General Discussion
• 
  Query spends more time on before plan

  Answered VigneshN 5.6K views 3 comments 0 points Most recent by emoreno November 2019Tips from the Team
• 
  TIMESTAMP query depending on vertica server location

  Answered ✓ pegazik 4.6K views 1 comment 0 points Most recent by SruthiA October 2019General Discussion
• 
  vertica joins weird behaviour

  Answered ✓ rajatpaliwal86 16.9K views 6 comments 0 points Most recent by Vertica_Curtis October 2019General Discussion
• 
  VMC: Query Synopsis

  robns 4.4K views 1 comment 0 points Most recent by LenoyJ August 2019General Discussion
• 
  Is modifying vconsole's report definition queries supported

  Answered P_Quinlan 6.7K views 2 comments 0 points Most recent by P_Quinlan August 2019General Discussion
• 
  Find and fix issues from Vertica query events

  Bryan_H 2K views 0 comments 0 points Most recent by Bryan_H August 2019Tips from the Team
• 
  How to optimize query

  michaeljack 37.9K views 14 comments 0 points Most recent by marcothesane July 2019General Discussion
• 
  Query Long Varchar via ODBC

  verban 14.8K views 5 comments 1 point Most recent by verban July 2019General Discussion
• 
  Query resulting in syntax error

  hsingh 4.5K views 1 comment 0 points Most recent by marcothesane July 2019General Discussion