Welcome to the Vertica Forum

Discussion List

• 
  Optimizing DISTANCE using projections

  Answered zun 48 views 1 comment 0 points Most recent by Hibiki July 12General Discussion
• 
  Using variables in Query

  Answered yehudit 52 views 1 comment 0 points Most recent by Bryan_H July 7General Discussion
• 
  Finding similar roles assigned

  Answered shekhar8249 53 views 2 comments 0 points Most recent by DaveT February 17General Discussion
• 
  Inconsistency in vertica query results

  Answered pegazik 151 views 6 comments 0 points Most recent by yun_hoe_kim February 14General Discussion
• 
  Last day of last completed quarter

  Answered ✓ pratheek238 87 views 4 comments 0 points Most recent by pratheek238 November 2021General Discussion
• 
  Time slots to dates

  Answered ✓ pestrid 114 views 5 comments 0 points Most recent by pestrid September 2021General Discussion
• 
  Query Progress

  Answered Rocky 99 views 1 comment 0 points Most recent by Bryan_H August 2021General Discussion
• 
  How do I globally enable JFMT?

  Answered ✓ Deb_Chatigny 594 views 5 comments 0 points Most recent by Jim_Knicely February 2021General Discussion
• 
  Same query executes 2 times in a row

  Answered ✓ zadvovl 558 views 4 comments 0 points Most recent by zadvovl December 2020General Discussion
• 
  Hybrid Flex table performance vs standard table

  Answered rajatpaliwal86 837 views 4 comments 0 points Most recent by Pieter_Sheth-Vo December 2020General Discussion
• 
  Insert random values in Fact Table

  Answered franciscoCA 419 views 2 comments 0 points Most recent by mosheg November 2020General Discussion
• 
  Any way to get query data dynamically while its executing.

  Answered ✓ sahil_kumar 889 views 8 comments 0 points Most recent by mosheg May 2020General Discussion
• 
  to_date function returns wrong result

  Answered martinc123 1.5K views 5 comments 0 points Most recent by mosheg May 2020General Discussion
• 
  About the performance of the query

  Answered ✓ yamakawa 537 views 2 comments 0 points Most recent by yamakawa April 2020General Discussion
• 
  What are some best practices for updating table statistics?

  Answered rjs_docs 544 views 1 comment 0 points Most recent by JoeGonzalezVertDBA April 2020General Discussion
• 
  Can you send a query to multiple subclusters?

  Answered GaryG 512 views 1 comment 0 points Most recent by skeswani April 2020General Discussion
• 
  When to resegment/broadcast?

  Answered kxu 663 views 3 comments 0 points Most recent by cp00634326 April 2020General Discussion
• 
  Different effects when dropping/adding nodes between Eon and Enterprise Modes?

  Question GaryG 535 views 0 comments 1 point Started by GaryG April 2020 General Discussion
• 
  Selectively retaining data from data collectors

  Answered kxu 518 views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Does ordering by lots of columns hurt performance?

  Answered Deb_Chatigny 583 views 3 comments 0 points Most recent by ChuckB April 2020General Discussion
• 
  Where can I find documentation for query performance and resource pools?

  Answered rjs_docs 562 views 2 comments 0 points Most recent by rjs_docs April 2020General Discussion
• 
  Hints with pre-ANSI joins

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

  Answered DreaBrandford 585 views 2 comments 0 points Most recent by DaveT April 2020General Discussion
• 
  SELECT statement performance improvements?

  Answered rjs_docs 530 views 1 comment 0 points Most recent by twall April 2020General Discussion
• 
  Planned concurrency and resource pools?

  Answered Deb_Chatigny 642 views 2 comments 0 points Most recent by JoeGonzalezVertDBA April 2020General Discussion
• 
  What are some query performance troubleshooting tips?

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

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

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

  Answered rjs_docs 506 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 514 views 1 comment 0 points Most recent by skamat April 2020General Discussion