2. Vector Concepts : Query Optimization
Share this page                  
Query Optimization
Analytical queries are the focus of Vector. It is essential that such queries have good information about the characteristics of the underlying data because the amount of data accessed can be great, and the sizes of intermediate processing stages must be properly estimated to produce optimal query plans.
To allow the system to generate optimal query plans, we highly recommend running optimizedb or CREATE STATISTICS if 10% or more of the data in a table has changed since the last optimization. Vector will automatically construct histograms from live data for those columns that do not already have histograms stored in the catalog.