OptimizeDB for Vectorwise
We always recommend that you always run Optimize DB once your data is first loaded.
Optimize DB is a fast and simple way to optimize Vectorwise for your data. Optimize DB does this by making an internal statistical model of your data. Vectorwise then uses that model to choose the query execution plan that will run the fastest.
We recommend running Optimize DB every time your total data changes by more than 20%.
- In the top menu tab under “Tools”, select “Tools” and click “Command Prompt”.
- To run Optimize DB, type optimized –zfq followed by the name of your database.
For the example shown it will be “optimized -zfq mydatabase”.
- Click “Enter”
Congratulations, Vectorwise is optimized for incredibly fast query response time.
Next Steps — Uninstall Vectorwise