Recommendations

We recommend you do the following when using direct query:

• Ingest data into Amazon S3 using partition formats of year, month, day, hour to speed up queries.

• Use limits on your queries to ensure you aren't pulling too much data back.

• Use Index State Management (where applicable) to maintain storage for materialized views and covering indexes.

• Drop acceleration jobs and indexes when they are no longer needed.

• When building skipping indexes, use bloom filters for high cardinality and min/max for large ranges. It is recommended you use value set on a high cardinality field.

• Use reference guides to export data to Amazon S3. You can use AWS logs such as CloudFront, CloudTrail, and Elastic Load Balancing.