analyze.sql 1.4 KB

123456789101112131415161718192021222324
  1. analyze table call_center compute statistics for columns;
  2. analyze table catalog_page compute statistics for columns;
  3. analyze table catalog_returns compute statistics for columns;
  4. analyze table catalog_sales compute statistics for columns;
  5. analyze table customer compute statistics for columns;
  6. analyze table customer_address compute statistics for columns;
  7. analyze table customer_demographics compute statistics for columns;
  8. analyze table date_dim compute statistics for columns;
  9. analyze table household_demographics compute statistics for columns;
  10. analyze table income_band compute statistics for columns;
  11. analyze table inventory compute statistics for columns;
  12. analyze table item compute statistics for columns;
  13. analyze table promotion compute statistics for columns;
  14. analyze table reason compute statistics for columns;
  15. analyze table ship_mode compute statistics for columns;
  16. analyze table store compute statistics for columns;
  17. analyze table store_returns compute statistics for columns;
  18. analyze table store_sales compute statistics for columns;
  19. analyze table time_dim compute statistics for columns;
  20. analyze table warehouse compute statistics for columns;
  21. analyze table web_page compute statistics for columns;
  22. analyze table web_returns compute statistics for columns;
  23. analyze table web_sales compute statistics for columns;
  24. analyze table web_site compute statistics for columns;