performance

Discussion List

• 
  How do aggregate projections affect the load performance?

  Answered Min_Yun_Chan 5.3K views 1 comment 0 points Most recent by marcothesane April 2020General Discussion
• 
  SELECT statement performance improvements?

  Answered rjs_docs 5.3K views 1 comment 0 points Most recent by twall April 2020General Discussion
• 
  Eon Mode - Performance if data is not in the Depot and policy to rehydrate

  Answered Min_Yun_Chan 11.8K views 3 comments 0 points Most recent by [Deleted User] April 2020General Discussion
• 
  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
• 
  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
• 
  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
• 
  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
• 
  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
• 
  ML - Feasibility and performance of analyzing all data on a Vertica cluster?

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

  Answered rajatpaliwal86 5.3K views 1 comment 0 points Most recent by ChuckB March 2020General Discussion
• 
  How to create text index on a flex table which has composite primary key

  Answered rajatpaliwal86 15K views 4 comments 0 points Most recent by rajatpaliwal86 February 2020General Discussion
• 
  order by on JOIN of tables is very slow

  Answered rajatpaliwal86 15.3K views 4 comments 0 points Most recent by rajatpaliwal86 January 2020Product Feedback
• 
  Joins on multiple(more than two) tables - extremely slow

  Answered rajatpaliwal86 32.5K views 9 comments 0 points Most recent by rajatpaliwal86 December 2019Product Feedback
• 
  How is the performance of Joins in Vertica?

  Answered ✓ rajatpaliwal86 5.5K views 1 comment 0 points Most recent by Bryan_H October 2019General Discussion
• 
  vertica joins weird behaviour

  Answered ✓ rajatpaliwal86 21.3K views 6 comments 0 points Most recent by Vertica_Curtis October 2019General Discussion
• 
  SAP Business Objects run on Vertica takes longer than Oracle.

  Answered JeansB 5.2K views 1 comment 0 points Most recent by JeansB September 2019General Discussion