After optimizing a data warehouse, you need to test its performance and check whether the optimization is effective.
If the table schema changes during the optimization, you need to delete original tables and create tables and partitions according to the optimization policy. You also need to adjust the test data provided in this tutorial to facilitate data import.
After creating tables and importing data, you can test the performance of the data
warehouse. You can record the relevant data in the following table and compare the
data with the performance benchmark.
| Test item | Test value |
|---|---|
| Data synchronization time | - |
| Occupied storage space | - |
| Query execution time | - |
| Estimated charge for a query | - |