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%.

  1. In the top menu tab under “Tools”, select “Tools” and click “Command Prompt”.
    OptimizeDB for Vectorwise

  2. To run Optimize DB, type optimized –zfq followed by the name of your database.
    For the example shown it will be “optimized -zfq mydatabase”.
    OptimizeDB for Vectorwise

  3. Click “Enter
    OptimizeDB for Vectorwise

Congratulations, Vectorwise is optimized for incredibly fast query response time.

Next Steps — Uninstall Vectorwise