Analyzing all tables in a schema

Moderator: NorbertKrupa

Post Reply
User avatar
becky
Intermediate
Intermediate
Posts: 118
Joined: Sat Apr 28, 2012 11:37 am

Analyzing all tables in a schema

Post by becky » Tue Nov 12, 2013 1:46 pm

Howdy,

Is there an option on the ANALYZE_STATISTICS function that will allow me to analyze all the tables in the schema, or do I have to do each table individually?
THANKS - BECKSTER
Top
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:
Contact JimKnicely

Re: Analyzing all tables in a schema

Post by JimKnicely » Tue Nov 12, 2013 1:48 pm

Becky,

Check out this post thread:

viewtopic.php?f=5&t=698
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Top
User avatar
becky
Intermediate
Intermediate
Posts: 118
Joined: Sat Apr 28, 2012 11:37 am

Re: Analyzing all tables in a schema

Post by becky » Tue Nov 12, 2013 2:51 pm

Oops, sorry, Jim... I should have searched and found that myself :oops: Thanks!
THANKS - BECKSTER
Top
Post Reply

Return to “New to Vertica Database Administration”