Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Analyze_statistics Auto-commit

It's always been that analyze_statistics() auto-commits.  I've confirmed that this is also still true in 7.1.  


The release notes from 7.0.2-1 have this change in them:



Catalog Engine

The ANALYZE_STATISTICS function incorrectly issued a commit. This issue has been resolved.


Could someone clarifiy what this change was since it analyze_statistics() still auto-commits in 7.1?







  • SruthiASruthiA Employee

    Thanks for mentioning about it.  It should be ANALYZE_CONSTRAINTS(). I will open a defect and get it changed in the Release Notes.   analyze_statistics() still auto-commits.





Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.