MaxCompute table performance depends on whether tables comply with table design specifications. Before optimizing MaxCompute tables, record baseline metrics so you can verify whether your optimizations are effective.
Capture the following metrics before and after each optimization:
| Metric | Value |
|---|---|
| Data synchronization time | — |
| Storage usage | — |
| Query execution time | — |
| Estimated charge for a query | — |
If your MaxCompute project uses subscription mode, also record the quantity of purchased resources.
Record storage usage
Log on to the DataWorks console.
Run the DESCRIBE command to query the physical storage size of a table or a partition.
Record query execution time and estimated charge
Log on to the DataWorks console, go to the Data Studio page, and create an ODPS sql node.
Use DataWorks to capture both metrics:
-
Estimated charge: Visible on the graphical user interface (GUI) while a node is running. You can also click
to view it. -
Query execution time: Available in the operational log after the node finishes.