Roger K

08/03/2023, 8:41 AM
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?