Hello, I am implementing z-ordering on my tables. For some of them I need to change the column order. And if I understand correctly, after changing the column order I also need to trigger recomputing the statistics.
I try to recompute the stats for the new order with "ANALYZE TABLE table_name COMPUTE STATISTICS " sql command but it fails with
ANALYZE TABLE is not supported for v2 tables.
A few of my questions:
• what are v2 tables?
• when are the column stats computed?