top | item 18409831

(no title)

radub | 7 years ago

[Cockroach Labs engineer here, I worked on statistics]

All table statistics are stored in a system table (system.table_statistics). CREATE STATISTICS scans the table, calculating statistics on a column, and adds a new row to system.table_statistics.

We still have a ways to go in making statistics automatic (right now it requires a manual call to CREATE STATISTICS) and more useful to the optimizer (which currently only uses basic stats). We're working on that right now for the 2.2 release.

discuss

SaifAlHarthi|7 years ago

What if the tables were partitioned, do you calculate local statistics or you aggregate the stats and expose it to the optimizer?

Lemaxoxo|7 years ago

Are you planning to support multivariate statistics?

radub|7 years ago

We plan to support cardinality estimations for multiple columns. Other than that there are no plans for multivariate stats in the near future.