This PR adds an initial support for collecting table statistics for cost-based query optimization. Specifically, it implements a command \analyze that counts the number of distinct values for each column of each relation. This information will be used to estimate predicate's selectivity in a following PR that performs join order optimization.
TODO: will add unit tests later for the \analyze feature.
pateljm
commented
8 years ago
This PR adds an initial support for collecting table statistics for cost-based query optimization. Specifically, it implements a command
\analyzethat counts the number of distinct values for each column of each relation. This information will be used to estimate predicate's selectivity in a following PR that performs join order optimization.TODO: will add unit tests later for the
\analyzefeature.