ANALYZE_WORKLOAD

Moderator: NorbertKrupa

Post Reply
User avatar
Julie
Master
Master
Posts: 221
Joined: Thu Apr 19, 2012 9:29 pm

ANALYZE_WORKLOAD

Post by Julie » Thu Aug 16, 2012 6:20 pm

Hi,

Is there a way to clear the information collected by the ANALYZE_WORKLOAD function? After running it with the "true" options several times I lost some of the recommendations that I had from the original run :(.

I'd like to clear the history and get back to the original recommendations from the first run if possible! Does anyone know how to do that?
Thanks,
Juliette

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: ANALYZE_WORKLOAD

Post by jpcavanaugh » Wed Aug 22, 2012 10:28 pm

Analyze workload is based on real load through the system so there is no way to go "back". You can clear it though the data collector and its control functions.

Post Reply

Return to “New to Vertica Database Administration”