# Collect and Utilize table statistics
<a name="emr-trino-performance-areas-collect-stats"></a>

 Collecting table statistics allows Trino’s cost-based optimizer to make informed decisions about join orders, filter pushdown, and partition pruning, resulting in better performance.

You can use the `ANALYZE` command to collect statistics for Hive or Iceberg tables:

```
ANALYZE sales;
```

Collecting statistics on wide tables can be taxing on resources. We recommend specifying a subset of columns that are used in joins, in filters, or in grouping operations.

This is another helpful command. It displays current statistics for a table to verify if statistics are up to date.

```
show stats for table_name;
```