Query

Discussion List

• 
  What are some query performance troubleshooting tips?

  Answered rjs_docs 5.2K views 1 comment 0 points Most recent by baron42bba April 2020General Discussion
• 
  Scheduled analyzed_statistics on a table

  Answered kxu 5.2K views 1 comment 0 points Most recent by baron42bba April 2020General Discussion
• 
  Best practices and tips for tuning analytical functions?

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

  Answered rjs_docs 5.3K 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 5.2K views 1 comment 0 points Most recent by [Deleted User] April 2020General Discussion
• 
  Memory usage and joins

  Answered kxu 5.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 5.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 5.6K 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 5.3K views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Optimizing a query with several joins

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

  Answered kxu 5.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 5.2K views 1 comment 0 points Most recent by s_crossman April 2020General Discussion
• 
  Does an unused resource pool reserve memory?

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

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

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

  Question kxu 2.1K views 0 comments 0 points Most recent by kxu April 2020General Discussion
• 
  Analyzing a constantly-loaded table

  Question kxu 2K views 0 comments 0 points Most recent by kxu April 2020General Discussion
• 
  Query dropped when node goes down

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

  Answered rajatpaliwal86 5.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 12.5K views 3 comments 0 points Most recent by ChuckB March 2020General Discussion
• 
  Joins on multiple(more than two) tables - extremely slow

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

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

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

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

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

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

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

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

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

  verban 18.6K views 5 comments 1 point Most recent by verban July 2019General Discussion