Use partitioning and bucketing
Partitioning and bucketing are two ways to reduce the amount of data Athena must scan when
you run a query. Partitioning and bucketing are complementary and can be used together.
Reducing the amount of data scanned leads to improved performance and lower cost. For
general guidelines about Athena query performance, see Top 10 performance
tuning tips for Amazon Athena