Search found 53 matches
- Mon Jun 25, 2012 9:19 am
- Forum: Vertica Performance Tuning
- Topic: Collecting statistics
- Replies: 1
- Views: 5950
Collecting statistics
Hi, A couple of questions around running the analyze_statistics command. 1. Can mulitiple analyze_statistics commands be run in parallel? 2. How much of an impact does this cause, is the table still usable for queries? I know this is very dependant on the hardware, but just an idea of "best practice...
- Thu Jun 21, 2012 5:22 pm
- Forum: New to Vertica Database Administration
- Topic: Error checking / capture
- Replies: 5
- Views: 13563
Re: Error checking / capture
Thanks, just what I need, does this also apply to version 5.0.7?
- Thu Jun 21, 2012 4:54 pm
- Forum: New to Vertica Database Administration
- Topic: Error checking / capture
- Replies: 5
- Views: 13563
Re: Error checking / capture
Hi Jim, Thanks for the reply, is there nothing that can be done internally with in vsql? How would I check the return code after each step within vsql and exit if there is an error? The SQL that I have creates about 50 new projections and drops the old ones, spliting this out would make a horrible s...
- Thu Jun 21, 2012 12:58 pm
- Forum: New to Vertica Database Administration
- Topic: Error checking / capture
- Replies: 5
- Views: 13563
Error checking / capture
Hi, I'm very new to Vertica. I want to run a batch of SQL statements, but if there is a failure it should exit, is this easy to do? For example in Oracle you would use "WHENEVER SQLERROR {EXIT [SUCCESS | FAILURE | WARNING ..... is there something similar in Vertica? Running the following type of pro...