Welcome to the Vertica Forum

Query

Discussion List

• 
  Any way to get query data dynamically while its executing.

  Accepted Answer sahil_kumar 138 views 8 comments 0 points Most recent by mosheg May 26General Discussion
• 
  to_date function returns wrong result

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

  Accepted Answer yamakawa 115 views 2 comments 0 points Most recent by yamakawa April 20General Discussion
• 
  What are some best practices for updating table statistics?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  Answered rjs_docs 119 views 1 comment 0 points Most recent by skamat April 1General Discussion
• 
  Memory usage and joins

  Answered kxu 109 views 1 comment 0 points Most recent by skamat April 1General Discussion
• 
  Is it possible to filter user queries based on cost?

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

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

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

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

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

  Answered kxu 111 views 1 comment 0 points Most recent by s_crossman April 1General Discussion
• 
  JFMT hints on merge?

  Accepted Answer Deb_Chatigny 109 views 2 comments 0 points Most recent by Jan_Soubusta April 1General Discussion
• 
  Tools for investigating query performance?

  Answered Deb_Chatigny 131 views 1 comment 0 points Most recent by siddyash April 1General Discussion
• 
  Does an unused resource pool reserve memory?

  Answered rjs_docs 105 views 1 comment 0 points Most recent by Pan April 1General Discussion
• 
  How do I globally enable JFMT?

  Accepted Answer Deb_Chatigny 105 views 1 comment 0 points Most recent by rroelke April 1General Discussion