Review these tips and make adjustments to increase your Presto queries performance.

• Always use TD_TIME_RANGE or TD_INTERVAL (with a link to Scheduling Presto Queries)

• Avoid using slow memory consuming operators such as

  • ORDER BY

  • COUNT(DISTINCT x)

For example, instead of using COUNT (DISTINCT x), use approx_distinct(x).

• Join processing

  • Tables should be joined in the order of a larger table to smaller tables.

  • Using a non-equi join condition slows down the query processing.

• Columnar storage characteristics

  • Choosing too many columns slows down query processing.

• Query result size

  • Generating too many rows takes time. Instead, use CREATE TABLE AS … or INSERT INTO or result_redirect magic comment.