Thread: Do I need to COMMIT an analyze statement?
Hello, something I have always wondered: If I run with autocommit turned OFF, do I need to commit an ANALYZE statement, or is that "non-transactional"? Thomas
On Friday, March 31, 2017, Thomas Kellerer <spam_eater@gmx.net> wrote:
Hello,
something I have always wondered:
If I run with autocommit turned OFF, do I need to commit an ANALYZE statement, or is that "non-transactional"?
The results are stored in a catalog table so they are transactional.
David J.
David G. Johnston schrieb am 31.03.2017 um 16:49: > On Friday, March 31, 2017, Thomas Kellerer <spam_eater@gmx.net <mailto:spam_eater@gmx.net>> wrote: > > Hello, > > something I have always wondered: > > If I run with autocommit turned OFF, do I need to commit an ANALYZE statement, or is that "non-transactional"? > > > The results are stored in a catalog table so they are transactional. Thanks. That's what I assumed. Just wanted to be sure. Thomas